Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlink Macro-links to other excel files
Ok...here's the situation:
At my company we have thousands of excel files that act as safet guides for performing maintenance to different machines. They ar divided up into categories with hundreds of excel files in eac folder. Using some old DOS commands, I can create a text file that displays th full network path to each excel file in a given folder. Example: Agitators.txt \\h2brwcmd1\EIGs\Papermill\No.1 PM\Agitators\4118 Agitator, Brok Tower.xls \\h2brwcmd1\EIGs\Papermill\No.1 PM\Agitators\4158 Agitator, (WEST) o West 400 Ton HD (4344).xls |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlink Macro-links to other excel files
And your question is ?
"tsummerv " wrote in message ... Ok...here's the situation: At my company we have thousands of excel files that act as safety guides for performing maintenance to different machines. They are divided up into categories with hundreds of excel files in each folder. Using some old DOS commands, I can create a text file that displays the full network path to each excel file in a given folder. Example: Agitators.txt \\h2brwcmd1\EIGs\Papermill\No.1 PM\Agitators\4118 Agitator, Broke Tower.xls \\h2brwcmd1\EIGs\Papermill\No.1 PM\Agitators\4158 Agitator, (WEST) of West 400 Ton HD 4).xls |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a macro in excel to hyperlink files | Excel Discussion (Misc queries) | |||
macro to print files from a list of links | Excel Discussion (Misc queries) | |||
Formulas containing links to other Excel files | Excel Discussion (Misc queries) | |||
E-mailing links to Excel files | Excel Discussion (Misc queries) | |||
Links in Excel Files | Excel Programming |