cell reference to another file

[bubbles1611]

Hey,
i am working on updating a spreadsheet i am using, and would liek it to
update with invoice no's such as:-
='S:\2005-2006 Sales\Invoices\[17142.xls]Sheet1'!$B$11

where 17142.xls is the other spreadsheet i want to get teh data out
of.
this is fine, however i want to have a cell "A3"on teh current
worksheet to tell the formula which invoice sheet to get teh value
from.
this is teh formula i hav etried:-

='S:\2005-2006 Sales\Invoices\[" & A3 & ".xls]Sheet1'!$B$11

does anyone have any ideas on how to put a relative cell reference in a
file path?

any ideas would be greatly appreciated.

Thanks
Tim

 

[Harlan Grove]

bubbles1611 wrote...
....

this is teh formula i hav etried:-

='S:\2005-2006 Sales\Invoices\[" & A3 & ".xls]Sheet1'!$B$11

does anyone have any ideas on how to put a relative cell reference in a
file path?

See

http://groups.google.com/group/microsoft.public.excel.worksheet.functions/msg/ac443753560f0075

(or http://makeashorterlink.com/?B34B15DCC ).