Feb 08 2022 06:58 AM
Hi, I have a huge list of hyperlinks and need a way/formula preferred to change app 400 links into the URL. Appreciate the help
Feb 08 2022 08:43 AM
Without using VBA, no, there's no way to do this.
How to change multiple hyperlink paths at once in Excel?
or make at own the steps...here the instructions
- Make a backup copy of the file
- Right click on the table tab
- show code
- Paste this code:
Private Sub Test()
Dim H A's hyperlink
For Each H In Me.Hyperlinks
H.Address = Replace(H.Address, "\Intern\falli\", "\Intern\EXPORT_IMPORT\falli\")
Next
end sub
- Click anywhere in the sub with the cursor
- Press F5 (you can't see anything, the mouse pointer may turn into an hourglass, wait)
- VBA editor too
- Save file
Hope I was able to help you with this info.
I know I don't know anything (Socrates)
Was the answer useful? Mark them as helpful!
This will help all forum participants.
Feb 08 2022 11:58 PM
@NikolinoDE thanks for all the info. Will take a a closer look and try to get it done this way.