Maybe...

=hyperlink("g:\general\blah\blah\" & A9 & "\file.pdf", "ABC")

akronpow wrote:

I am trying to create a macro so that I can click a button and a
hyperlink is created, referencing a network location where the location
is dependent upon a value in another cell.

So for example, the hyperlink to be created in cell E3 would be
"=hyperlink("G:\General\Blah\Blah\"cell A9"\file.pdf")"

Also, I want the hyperlink text to just say "ABC"

How does this happen?

--
akronpow
------------------------------------------------------------------------
akronpow's Profile: http://www.excelforum.com/member.php...o&userid=29100
View this thread: http://www.excelforum.com/showthread...hreadid=488213

--

Dave Peterson