| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to hyperlink individual files in multiple files
You don't need a macro.
Let's say your list of files is in column A, for example in A1: C:\music.xls with each entry having the path name and file name. In B1 enter: =HYPERLINK("file:///"&A1) and copy down. This will give you a nice list of "click-able" hyperlinks to the file listed in column A -- Gary''s Student gsnu200712 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| multiple csv files into individual tabs | Excel Discussion (Misc queries) | |||
| importing multiple text files into individual worksheets in workbook | Excel Programming | |||
| set up a macro to copy/ move sheets to individual files | Excel Programming | |||
| How can I use a macro to hyperlink multiple files at once? | Excel Programming | |||
| Import multiple files macro can't find files | Excel Programming | |||
Linear Mode
