Hyperlink to A File on Sharepoint

[RooparDE11]

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