Hyperlink Macro-links to other excel files

T

tsummerv

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
 
J

Jim Cone

And your question is ?

tsummerv > said:
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
Click to expand...
400 Ton HD 4).xls
 
T

tsummerv

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
 
Top