Hi all,
Not sure if this is possible, but here goes...
I have a list of around 300 files in a worksheet. I am trying to link each cell entry to its corresponding file. I know how to manually create a hyperlink, but it's going to take some time. Can anyone suggest a means of automatically getting Excel to find each file (they're all located in the same place) and create a link to that file.
TIA,
SamuelT
Last edited by SamuelT; 08-03-2007 at 09:27 AM.
Hello SamuelT,
This macro prompts you for the file's folder path. You only need the file name in the cell. It then finds the file, and creates a hyperlink to it.
To Install the Macro:
Please Login or Register to view this content.
1. Copy the Macro code above using CTRL+C
2. Open Excel and Right Click on any Sheet Tab
3. Click on View Code in the pop up menu
4. Use ALT+I to activate the VBE Insert Menu
5. Press the letter m to insert a Standard Module
6. Paste the macro code using CTRL+V
7. Save the macro using CTRL+S
8. Close the VBE and return to excel using ALT+Q
Sincerely,
Leith Ross
Many thanks Leith. Will give this a go!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks