Linked workbooks - variable wb path.

Tech-Archive recommends: Fix windows errors by optimizing your registry


Hi all,

I am working on a project which will use linked workbooks.

Ok, what I would like to do is have a 'configuration ***' where I
could include some variables like the path for certain linked
workbooks.
In Book1, Cell A1 = \\network_path\
In Book1, Cell A2 <-- here I would like to know if there is a function
(way to do it either in Excel or VBA) to 'build' the cell reference to
the external workbook.

I tried = INDIRECT(A1&"[workbook]the_sheet_name'!Cell_reference") but
that does not seem to work - I also tried other variations but no
luck...

Basicaly I just want to be able to change one cell (A1) to change all
links i the workbook.

Any sujestions?

Thanks,
Tony


--
Tone
------------------------------------------------------------------------
Tone's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25356
View this thread: http://www.excelforum.com/showthread.php?threadid=388379

.

Quantcast