I have a file name(eg. C:\Users\BD\Desktop\Book1.xlsx) copied onto my clipboard. Is there a macro to insert it as a hyperlink in the active cell?
If possible I would like to keep the friendly name as "Link" for all insertions.
Thx!
I have a file name(eg. C:\Users\BD\Desktop\Book1.xlsx) copied onto my clipboard. Is there a macro to insert it as a hyperlink in the active cell?
If possible I would like to keep the friendly name as "Link" for all insertions.
Thx!
Last edited by Xx7; 10-20-2011 at 04:49 PM.
How's that work?Please Login or Register to view this content.
Works great, thanks!
What if I wanted to display the file name (eg. "Book1") instead of "link". Is this easy to do?
Last edited by Xx7; 10-20-2011 at 04:51 PM.
There's probably a better way, but:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks