Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Turning a text file name into a search and linking the file as a hyperlink
Can anyone help with a Macro?? I Have a large list of file names
(16000) in excel and need to create a hyperlink link to the actual files stored in a variety of subfolders to facilitate a search on the list and the hyperlink clicked to access the file. At the moment I need to identify what I need on the list and then do a search for each file required in the subfolders which takes ages. I could link the files individually but this is only reference data and I that would take about as long as it would to find the files by searching individually, any help appriciated, even if its just to tell me it's more hassle than it's worth! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Turning a text file name into a search and linking the file as a hyperlink
see http://www.mvps.org/dmcritchie/excel...MakeHyperlinks
You may have to look around the page a little if that is not exactly what you mean. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "AlistairM" wrote in message oups.com... Can anyone help with a Macro?? I Have a large list of file names (16000) in excel and need to create a hyperlink link to the actual files stored in a variety of subfolders to facilitate a search on the list and the hyperlink clicked to access the file. At the moment I need to identify what I need on the list and then do a search for each file required in the subfolders which takes ages. I could link the files individually but this is only reference data and I that would take about as long as it would to find the files by searching individually, any help appriciated, even if its just to tell me it's more hassle than it's worth! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking files "File Not Found" | Excel Discussion (Misc queries) |