hi
not sure if this is possible but say i have 6 files in a folder on my desktop and excel has 6 entries on sheet1 each one hyperlinks to the selected file in the folder
my question is can i move the folder off the desktop to a different drive on the same computer and automatically update hyperlinks to the new address
this is a works computer
if not i know i can edit hyperlink and it takes me through about 5 different screens to get to the location of file its a bit long winded
cheers colin
hi
would it be possible to look for folder as its still the same name and update with vba / macro
cheers colin
How about this.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Hi
Will have a look when at work to night many thanks will let you know how I get on col
Last edited by AliGW; 02-04-2019 at 02:04 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks