| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
need to hyperlink to 100 files in the excel sheet
hi all,
I have included 100 file names from a folder in an excel sheet, i need to give hyperlink for all the files, Please help me with a macro. Thanks & Regards Anil Hungund |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
need to hyperlink to 100 files in the excel sheet
If the filenames are in A1:A100, you can use something like this in B1:
=hyperlink("File:////" & a1,"Clickme!") and drag down. anil wrote: hi all, I have included 100 file names from a folder in an excel sheet, i need to give hyperlink for all the files, Please help me with a macro. Thanks & Regards Anil Hungund -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to hyperlink pdf files in excel spreadsheet | Excel Discussion (Misc queries) | |||
| Using keyboard only, how can I go to a hyperlink in Excel sheet? | Excel Discussion (Misc queries) | |||
| Look up actual files from a list in excel and enter as a hyperlink | Excel Discussion (Misc queries) | |||
| hyperlink to specific sheet in excel | Excel Worksheet Functions | |||
| Hyperlink to specific sheet in Excel Web File | Links and Linking in Excel | |||
Hybrid Mode
