Hyperlink of pdf files to Excel

Closed
sandy - May 31, 2012 at 12:04 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - May 31, 2012 at 10:35 AM
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

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 544
May 31, 2012 at 10:35 AM
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