Linking the worksheets: question about syntax

  • Thread starter Thread starter Dmitry Smirnov
  • Start date Start date
D

Dmitry Smirnov

Hi, All!

I'm just a general user of Excel and often use formulas like:
"[Budget.xls]Annual!C10". My question is - how can I change that formula in
order to retrieve the name of XLS file from a cell instead specifying it
directly?

I.e. some cell (ex. A1) contains "Budget.xls" text.
And I'd like to use formula like "[#A1#]Annual!C10", where #A1# is syntax
i'd like to know.

Thanks in advance.

SDmitry.
 
=INDIRECT("'" & A1 & "'!C10")

Unfortunately, INDIRECT doesn't work with closed workbooks.
 
Tim Zych said:
=INDIRECT("'" & A1 & "'!C10")

Unfortunately, INDIRECT doesn't work with closed workbooks.


Dmitry Smirnov said:
Hi, All!

I'm just a general user of Excel and often use formulas like:
"[Budget.xls]Annual!C10". My question is - how can I change that formula in
order to retrieve the name of XLS file from a cell instead specifying it
directly?

I.e. some cell (ex. A1) contains "Budget.xls" text.
And I'd like to use formula like "[#A1#]Annual!C10", where #A1# is syntax
i'd like to know.

Thanks in advance.

SDmitry.
Click to expand...
Click to expand...
 
Back
Top