software

I'm trying to update links based on a cell value.
For Example: A1 thru A4 has the values 21,22,23, and 24 respectivly. My
link in B2 is ='C:\temp\[Cash Report 12-22-05.xls]Sheet1'!$D$5.

Is there a way that I can have the link in B2, change to 12-23-05(A2's
Value) without doing a manual find and replace for each cell? If there is a
macro way to do this that would be great too.

Thanks in Adavance!

Vick

If the resulting file name will be open, you can use =indirect(). But that will
fail if the quot;sendingquot; workbook is closed.

How about just
Edit|Links|change source?

Vick wrote:
gt;
gt; I'm trying to update links based on a cell value.
gt; For Example: A1 thru A4 has the values 21,22,23, and 24 respectivly. My
gt; link in B2 is ='C:\temp\[Cash Report 12-22-05.xls]Sheet1'!$D$5.
gt;
gt; Is there a way that I can have the link in B2, change to 12-23-05(A2's
gt; Value) without doing a manual find and replace for each cell? If there is a
gt; macro way to do this that would be great too.
gt;
gt; Thanks in Adavance!
gt;
gt; Vick

--

Dave Peterson

are there anyway to work around the limitation that the sending file needs to
be open?

regards
Gerrit

quot;Dave Petersonquot; wrote:

gt; If the resulting file name will be open, you can use =indirect(). But that will
gt; fail if the quot;sendingquot; workbook is closed.
gt;
gt; How about just
gt; Edit|Links|change source?
gt;
gt; Vick wrote:
gt; gt;
gt; gt; I'm trying to update links based on a cell value.
gt; gt; For Example: A1 thru A4 has the values 21,22,23, and 24 respectivly. My
gt; gt; link in B2 is ='C:\temp\[Cash Report 12-22-05.xls]Sheet1'!$D$5.
gt; gt;
gt; gt; Is there a way that I can have the link in B2, change to 12-23-05(A2's
gt; gt; Value) without doing a manual find and replace for each cell? If there is a
gt; gt; macro way to do this that would be great too.
gt; gt;
gt; gt; Thanks in Adavance!
gt; gt;
gt; gt; Vick
gt;
gt; --
gt;
gt; Dave Peterson
gt;

Check your other post for more replies.

Gerrit wrote:
gt;
gt; are there anyway to work around the limitation that the sending file needs to
gt; be open?
gt;
gt; regards
gt; Gerrit
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; If the resulting file name will be open, you can use =indirect(). But that will
gt; gt; fail if the quot;sendingquot; workbook is closed.
gt; gt;
gt; gt; How about just
gt; gt; Edit|Links|change source?
gt; gt;
gt; gt; Vick wrote:
gt; gt; gt;
gt; gt; gt; I'm trying to update links based on a cell value.
gt; gt; gt; For Example: A1 thru A4 has the values 21,22,23, and 24 respectivly. My
gt; gt; gt; link in B2 is ='C:\temp\[Cash Report 12-22-05.xls]Sheet1'!$D$5.
gt; gt; gt;
gt; gt; gt; Is there a way that I can have the link in B2, change to 12-23-05(A2's
gt; gt; gt; Value) without doing a manual find and replace for each cell? If there is a
gt; gt; gt; macro way to do this that would be great too.
gt; gt; gt;
gt; gt; gt; Thanks in Adavance!
gt; gt; gt;
gt; gt; gt; Vick
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson