Hyperlink of pdf files to Excel

Closed
Report
-
Posts
2847
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 13, 2022
-
Hello,
I created hyperlinks of around 100 pdf files which is inside a folder say "Reports" to an excel file. But now I need to change the folder name to Reports 2012. my question is whether I need to manually change all the 100 hyperlinks or any shortcuts are ther?
plz help,its urgent..


1 reply

Posts
2847
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 13, 2022
491
Hi Sandy,

Something you can try is putting the full path in the cell itself and then selecting all cells with paths and running the following macro:

Sub ChangeTextToHyperlink()
Selection.Hyperlinks(1).Address = Selection.Hyperlinks(1).TextToDisplay
End Sub

This will turn the text entered in the cell into hyperlink text.

Hope this helps.

Best regards,
Trowa
0