Using a Filename as a variable or reference
Posted by Mike on November 13, 2001 3:39 AM
Here is my problem. I have one spreadsheet of data which is a downloaded file which will never change format. I am using the INDIRECT command to pass the Filename and Folder location of this data spreadsheet from cells on my new spreadsheet, in order to reference this data file in a formula.
The problem I am having is that it only works when the data file is open in Excel first. Is there any way to write a formula so that the data file does not need to be open? I have tried specifying the whole complete path location (eg. 'F:\JV\Model\[datafile.xls]sheetname'!cellrange) but this does not work either.