Re: file path: reference to other workbooks
- From: "muster" <muster@xxxxxxxxx>
- Date: 28 Jul 2006 10:59:13 -0700
Thank you all.
My intention at first is getting data from a file that is not opened. I
realised that is probably not feasible. I have to write a function to
do that.
But suppose the file is opened. Now I get my file name in a cell, say
A1, which named "LastFile". What is the correct syntax to reference a
cell in "LastFile"? I can't use explicit file name, because it will
change.
Harlan Grove wrote:
Barb Reinhardt wrote...
In order for this to work, the workbook must be opened. Try...
='c:\abc\[june.xls]total'!a1
If the workbook were open, the formula
=[june.xls]total!A1
would be sufficient because Excel won't load multiple files with the
same base filename, e.g., june.xls, into memory at the same time.
.
- References:
- file path: reference to other workbooks
- From: muster
- Re: file path: reference to other workbooks
- From: Harlan Grove
- file path: reference to other workbooks
- Prev by Date: help with functions
- Next by Date: Re: how to get formula content of a cell?
- Previous by thread: Re: file path: reference to other workbooks
- Next by thread: Re: file path: reference to other workbooks
- Index(es):
Relevant Pages
|
