Hyperlink of pdf files to Excel [Closed]

Report
-
Posts
2757
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 8, 2021
-
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
2757
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 8, 2021
462
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!