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

[irsmalik]

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

[twinnyfo]

irsmalik,

The basic syntax for following a hyperlink in VBA is this:

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?

[ADezii]

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

[irsmalik]

Dear ADZii

thanks for your reply...I will check your idea and will again reply you.... thanks again.
irsmalik

[irsmalik]

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

[Naheedmir]

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.

[irsmalik]

Dear Naheedmir

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

Thanks