use cell contents to reference other workbooks

[Jack]

I need to be able to enter a workmanbook name in a cell,
then use a reference to that cell in formulas (instead of
the workbook name) to reference data in the other
workbook. I cannot figure out the syntax. Is this
possible?

 

[SMILE]

Hi
Try
Insert|Name|Define.

I am not sure you mean this?

Toms

 

[Norman Harker]

Hi Jack!

Try as an Example:

=INDIRECT("'["&A1&"]Sheet1'!A14")

Returns A14 in Sheet1 of the workbook named in A1

With INDIRECT the workbook needs to be open.

But if the workbook is closed then you will have to use a function
developed last year by Harlan Grove:

See:
http://www.google.com/[email protected]

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.