Use of Indirect function to fetch data from another Excel file

B

Boon8888

Hi, my title probably explains it all. I'm having trouble getting the
indirect function to fetch data from another Excel file when the path
is given in another cell.

Basically I have column in my spreadsheet that computes the path and
desired cell of another Excel file of which to grab the data from.

So say column B has a whole bunch of cells that have *values* like:

'\\server\folder1\[example.xls]sheet1'!C7
 
D

Dave Peterson

=Indirect() won't work with a closed workbook.

Harlan Grove wrote a UDF called PULL that will retrieve the value from a closed
workbook.

You can find the function at Harlan's FTP site:
ftp://members.aol.com/hrlngrv/
Look for pull.zip
Hi, my title probably explains it all. I'm having trouble getting the
indirect function to fetch data from another Excel file when the path
is given in another cell.

Basically I have column in my spreadsheet that computes the path and
desired cell of another Excel file of which to grab the data from.

So say column B has a whole bunch of cells that have *values* like:

'\\server\folder1\[example.xls]sheet1'!C7
Click to expand...
 
Top