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
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - May 31, 2012 at 10:35 AM
Related:
- Hyperlink of pdf files to Excel
- Save as pdf download - Download - Other
- Excel date format dd.mm.yyyy - Guide
- Excel to pdf converter free download - Download - PDF
- Transfer data from one excel worksheet to another automatically - Guide
- Tamil pdf to word ✓ - Word Forum
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
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:
This will turn the text entered in the cell into hyperlink text.
Hope this helps.
Best regards,
Trowa
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