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
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - May 31, 2012 at 10:35 AM
Related:
- Hyperlink of pdf files to Excel
- Save as pdf office 2007 - Download - Other
- Pdf xchange presentation mode - Guide
- Number to words in excel - Guide
- Pdf wiederherstellen - Guide
- 1st, 2nd, 3rd position formula in excel pdf - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
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