By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
462,395 Members | 526 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 462,395 IT Pros & Developers. It's quick & easy.

How to create Hyperlink in a Excel File which is placed in Google Drive

P: 89
Hellow friend...

I have a folder in my Google Drive... Here is an Excel File name Correspondence. it contain the record of incoming / outgoing letters which are in pdf format. These pdf are also stored in the same folder in Google Drive...

I want to create Hyperlinks in this excel file. Then I want to give the Link of this excel to any one who want to open these letter using this Correspondence file.

I am looking for help... Any one who is expert in excel....
Thanks
Irsmalik
4 Weeks Ago #1
Share this Question
Share on Google+
6 Replies

twinnyfo
Expert Mod 2.5K+
P: 3,529
irsmalik,

The basic syntax for following a hyperlink in VBA is this:
Expand|Select|Wrap|Line Numbers
  1. Call FollowHyperlink(Address:="YourFullURLHere")
I think you are asking for much more than that, but if you give someone the link to the excel spreadsheet and the spreadsheet has hyperlinks to the files, I'm not sure what else really needs to be done.

Am I missing something obvious, here?
4 Weeks Ago #2

ADezii
Expert 5K+
P: 8,741
For the purposes of this Demo, I have created a Folder named Demo in Google Drive. Within this Folder I copied a File named Correspondence.xlsx. To now create a Link in an Excel File so that anyone can connect to this File:
  1. In Google Drive:
    1. Dbl-click the Demo Folder to Open it.
    2. Right-click on the File Correspondence.xlsx.
    3. Select Share, then click Change to anyone with the Link.
    4. Select Copy Link (it's now in the Clipboard).
    5. Click Done, then Sign out.
  2. In Excel:
    1. Click any Cell to select it.
    2. Right-click, then Hyperlink.
    3. At the Top, enter the Text to display for the Hyperlink.
    4. At the bottom, Paste the Link to Correspondence.xlsx that you previously copied.
    5. Anyone with this Excel File should now be able to click on this Link and navigate directly to Correspondence.xlsx.
    6. Alternatively, you can simply paste the URL into the Address Bar of any Browser to navigate to this File
4 Weeks Ago #3

P: 89
Dear ADZii

thanks for your reply...I will check your idea and will again reply you.... thanks again.
irsmalik
4 Weeks Ago #4

P: 89
Dear friends... thanks to you all.

Google Sheets has solved my problem... Now I can use this sheet with hyper links... and I will give a link of this sheet to access my record...

irsmalik
4 Weeks Ago #5

P: 41
Hello,
To insert a hyperlink, you need to click on Insert tab > Link. In the dialog box, select the option 'Sheets in this spreadsheet' and click on the sheet for which you want to generate the hyperlink.
4 Weeks Ago #6

P: 89
Dear Naheedmir

Thanks for your reply.... I will try your guide lines.

Thanks
4 Weeks Ago #7

Post your reply

Sign in to post your reply or Sign up for a free account.