Variable in a hyperlink

[ssgmiami]

I have a worksheet that contains a hyper link to another wookbook.

example:
c:\Workbooks\Folder Name\YourData.xls

where "Folder Name" is the user's private data folder.

I would like to make the hyperlink dynamic by substituting the value in a named range for the "Folder Name" portion of the hyper link.

Something like this:
C:\Workbooks\"Named Range containing user's folder"\YourData.xls

That way the link will work for many different users.

Can this be done?

 

[texasalynn]

here is a function that you might add to your sheet so that you can apply to your formula

http://www.vbaexpress.com/kb/getarticle.php?kb_id=768