RooparDE11
New Member
- Joined
- Sep 24, 2014
- Messages
- 4
So I'm trying to find a way to hyperlink a file on a sharepoint 2010 to my excel spreadsheet using VBA initiate by a CommandButton. Is this possible?
I also want it to choose the file based on the value (name) in column 2 (B) and put the hyperlink in column 12 (L) of the same row.
I've created a button for inputting the folder's URL by the user. So it can reference that URL that's stored on the Reference sheet at F106 as a hyperlink. If this in not a good way to do it then I'm open to help.
Thanks
I also want it to choose the file based on the value (name) in column 2 (B) and put the hyperlink in column 12 (L) of the same row.
I've created a button for inputting the folder's URL by the user. So it can reference that URL that's stored on the Reference sheet at F106 as a hyperlink. If this in not a good way to do it then I'm open to help.
Thanks