INDIRECT? retrieve data from another workbook

[Ged Salter]

I am trying to retrieve a range of cell data from a closed workbook, but the workbook name is a variable in a cell referenced in a worksheet "Analysis" Cell B1.

The data is on a workbook whose File path is "C:\Users\61458\Desktop\TEST\Windows32\data" and worksheet called "Summary" and the cell data is a range of A1:B30.


I have tried the following but just returns an error.

=INDIRECT("'C:\Users\61458\Desktop\TEST\Windows32\data\[Analysis!&B1&]" Summary "'!$A$1:$B$30")

The workbook at path will be closed, but if need be I could open it using a macro which will access the variable file name

Hope you can help

[spencer_time]

I'm just posting as a way to follow this post. If there is a cleaner way to do this, I'm sorry.