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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlink Macro-links to other excel files
Thanks for your responses. Sorry about not specifying a question. Thi
is what I'm trying to do: My question is how do I take a column of full network paths t different excel files (eg. \\h2brwcmd1\eigs\....) and: #1: Create a macro that will use the network path to make hyperlink? #2: Rename the created hyperlinks to display only the file name minu the network path in front of it and minus the '.xls' at the end -- Message posted from http://www.ExcelForum.com |
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 |