Linking to Another Workbook

[Josh]

I want to know if it is possible to type in the name of a
workbook in a cell and then have Excel link to that
workbook and retrieve information from it. If so, how is
it done?

Thanks,
Josh

 

[JE McGimpsey]

One way:

Enter the = sign in the destination cell.

Navigate to the target workbook, select the cell, then press enter.

XL will fill in the required reference info.

 

[Josh]

I know how to do that, but I want it to link to the
workbook without having to navigate to it...just by
typing in the file name (since the files will always be
different).

Josh

 

[Frank Kabel]

Hi
just do as JE suggested and see what Excel has inserted

Or enter something like
='c:\temp\[filename.xls]sheetname'!A1