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 Moderator 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..


1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator 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
0

Similar discussions

How to convert the tamil pdf file to tamil word file
varathalakshmi -
karthik -

12 responses
How to send audio in Instagram
suyaprakash8429 -
Andy._Tani -

2 responses
How to convert the Tamil Word doc to Tamil PDF?
Singh -
Peter -

3 responses
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