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 |
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 |
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 |
All times are GMT +1. The time now is 08:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com