Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Use of Indirect function to fetch data from another Excel file
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Use of Indirect function to fetch data from another Excel file
=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 Boon8888 wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel 2003, Convert EXISTING Worksheet Data to XML? | Excel Discussion (Misc queries) | |||
Importing data into Excel | Excel Discussion (Misc queries) | |||
How do I automate upload of data from one excel file to another? | Excel Worksheet Functions | |||
Weekly Transaction Processing | Excel Worksheet Functions |