Previous Topic Next Topic

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 Contributor Last seen December 27, 2022 - 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..


Related:

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 555
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

Similar discussions

Why do my PDF documents open in Word?
jills -
tinman -

32 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response