variable link

[daniel chen]

Is it possible to make a Hyperlink be variable to what is in a reference
cell?
Let say a button "GO" is assigned to hyperlink file:///C:\Temp\ABC.xls
cell(A1) = "ABC"
How do/can I make the hyperlink look something like
file:///C:\Temp\Cell(A1).xls
Appreciated.

 

[Tom Ogilvy]

Look at the Hyperlink worksheet function.

You can construct your string as an argument to that.

 

[daniel chen]

Hi, Tom
No, It did not do what I wanted.
I entered the following :
Cell(A1) ="ABC"
Cell(B1) =HYPERLINK("C:\Temp\ABC.xls", A1)
the result was that Cell(B1) displayed "ABC" and hyperlinked to open
"C:\Temp\ABC.xls"
when Cell(A1) ="DEF", Cell(B1) displayed "DEF" but it was still
hyperlinked to open "C:\Temp\ABC.xls"
What I want is to open "C:\Temp\DEF.xls" , as specified in Cell(A1).
Thanks for your help.

 

[Dave Peterson]

A lot of people swear by John Walkenbach's "Excel 2004 Formulas".

Debra Dalgleish has a giant list of books that cover formulas, VBA, general and
lots more.

I think I'd print it and take it to my favorite bookstore to find the one I
liked best.

It sounds like you'd probably want to limit your review to the Formulas and
General section.

The VBA section covers macros.