Linking to Another Workbook

  • Thread starter Thread starter Josh
  • Start date Start date
J

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
 
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.
 
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
 
Hi
just do as JE suggested and see what Excel has inserted :-)

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