Hello,

I am trying to reference a cell in a another workbook, for example

E:\CoreData\[C_SWAreaPerformanceData.may05.xls]PReports'!$F$31

This works fine, but I need to use something like a wild card as the
months change and I need the cell to read the current month. This is
what I have tried:

E:\CoreData\[C_SWAreaPerformanceData.*.xls]PReports'!$F$31

Excel does not like this, so is there another way of referencing the
cell?

Thanks
P


--
Pootler
------------------------------------------------------------------------
Pootler's Profile: http://www.excelforum.com/member.php...o&userid=23977
View this thread: http://www.excelforum.com/showthread...hreadid=375970

Assume...

E:\CoreData\[C_SWAreaPerformanceData.
is in Cell A1

may05
is in Cell A2

..xls]PReports'!$F$31
is in cell A3

Formula in A4 =
=INDIRECT("'"&A1&A2&"'!"&A3)

Change cell A3 each month.

HTH,
--
Gary Brown

Please rate this posting if it is helpful to you.


"Pootler" wrote:


Hello,

I am trying to reference a cell in a another workbook, for example

E:\CoreData\[C_SWAreaPerformanceData.may05.xls]PReports'!$F$31

This works fine, but I need to use something like a wild card as the
months change and I need the cell to read the current month. This is
what I have tried:

E:\CoreData\[C_SWAreaPerformanceData.*.xls]PReports'!$F$31

Excel does not like this, so is there another way of referencing the
cell?

Thanks
P


--
Pootler
------------------------------------------------------------------------
Pootler's Profile: http://www.excelforum.com/member.php...o&userid=23977
View this thread: http://www.excelforum.com/showthread...hreadid=375970