Hyperlink of pdf files to Excel [Closed]

Question

Hyperlink of pdf files to Excel [Closed]

Report

sandy - May 31, 2012 at 12:04 AM
TrowaD

Posts: 2757
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: June 8, 2021

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

Hyperlink of pdf files to Excel
How to hyperlink multiple pdf files in excel - How-To - Excel
Convert active excel wksht to pdf file ✓ - Forum - PDF
Open pdf file using command buttong in excel ✓ - Forum - PDF
How to take a screenshot of a pdf file - How-To - PDF
Pdf file ki mb kaise kam kare - How-To - Software

1 reply

Ask a question

TrowaD · Answer 1 · 2012-05-31T10:35:03-0400

Answer 1 / 1

TrowaD

Posts: 2757
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: June 8, 2021

462
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

Hyperlink of pdf files to Excel [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!