file path: reference to other workbooks
- From: "muster" <muster@xxxxxxxxx>
- Date: 28 Jul 2006 08:35:38 -0700
The file links to different workbooks by conditions, I can get the file
name, path, etc,
such as:
in A1: ="c:\abc\"&lastmonth&".xls" --> c:\abc\june.xls
or A1: ="c:\abc\"&"["lastmonth&".xls]" --> c:\abc\[june.xls]
I name A1 as LastFile, how can I use it to reference a cell in that
file? like
=c:\abc\[june.xls]total!a1
I tried a few combinations but didn't work, what is the correct format?
Thank you.
.
- Prev by Date: Formula to find last value in a range & then offset
- Next by Date: Re: ADDING/SUBTRACTING FROM RIGHT TO LEFT
- Previous by thread: Formula to find last value in a range & then offset
- Next by thread: Re: file path: reference to other workbooks
- Index(es):