I am looking to copy files referenced as hyperlinks in an Excel worksheet to a directory specified in the macro. Attached is the Excel file (the spreadsheet is currently in the same directory as the referenced files).
Ideally, I would like to select a range of cells with hyperlinks and only have those selected hyperlinked files copied over. I tried few scripts by Googling answers, but none seemed to work. Any ideas? Thanks..
Please Login or Register to view this content.
If solved remember to mark Thread as solved
Made a slight correction to your script and go it to work. Thanks.
Please Login or Register to view this content.
I have made some additional changes to the code for further refinement and it works, so long as the spreadsheet is saved in the same directory as the files it hyperlinks to.
However, if the spreadsheet references files outside the current directory, it does not work (e.g. hyperlink show Travel/chicago.docx, with the cell showing chicago.docx). Any ideas how to modify it to work with file inside a directory as well as sub-directories? Thx..
Latest code is below...
Please Login or Register to view this content.
attach please a new sample file for testing
Hi, Brawnystaff,
from what I understand: maybe alter the hyperlinks to point to the new directory as they still should point to the old directory?
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Thanks HaHoBe..rather than put the path in each hyperlink, I just put it in cell A1 and reference it in the macro. Updated code below. Will mark this as solved..
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks