Referencing a Cell to Use a Specific Workbook

I want to reference a workbook using a cell reference.

Example:

Cell B2 in Workbook2 has the text:
Workbook1

Cell B3 in Workbook2 should look like:
='[Workbook1.xls]Sheet1'!$A$1'
to link cell B3 in Workbook2 with Cell A1 in Workbook1

I need to make it so that the text from Cell B2 in Workbook2 is plugged into Cell B3 in Workbook2.
So I thought it would look something like this:
='[(=B2).xls]Sheet1'!$A$1'

Thanks for the Help!

Hi gittleman..
For this you have to first copy the path of workbook one...
only then you will be able to move further to refer the cell..



Don't forget to click *

After that you can use the address function to refer to that cell ..

but you have to change one of its last argument ies sheet name with the path of the workbook 1


Don't forget to click *

Hi FDibbins!

Sorry I haven't responded I haven't had the time but I am looking to use the formula on closed workbooks. Can you please elaborate on the "Morefunc add-in" function please.

Thanks!

http://www.ashishmathur.com/tag/morefunc/

Sorry but this still comes up with a reference error.