Hello, I wonder if anyone can help me.
I have a excel document full of hyperlinks, and suddenly all hyperlinks have changed from one drive on my computer to another one.
Is there any way I can change a small sector of the wrong hyperlinks and change it to the correct one (with control f) as there is only one pert of the link that is incorrect...
Any help greatly appreciated.
Thank You
E
Try this macro editing the OldString and NewString values appropriately.
Please Login or Register to view this content.
Martin
How do I input a macro :S
ALT F11, Insert Module, Paste in code, Alt F11 back to workbook. View ribbon, macros.
When I press F11 it takes me to a chart
OK Sorry. I forgot to press Alt.
I have now put in the macro and the code, but it makes no difference what so ever.
Any ideas?
Will this work if I only want to change one part of the link?
The code replaces the part of the link specified in OldString with the text specified in NewString. Have you actually run the macro?
If you can supply an example of the old hyperlink and its corresponding new one, I can make the adaptations to the code for you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks