Hi,

I have a problem where Im building up a file name based on values in a
cell and then doing a sum of a particular column from that file name I
built up. I can do the summing no problem, but cant make the file name
correctly.

I have used the INDIRECT method to build the file name but I need to
have those files actually open as well, which i dont want.

The formual i am using is :

=SUM(INDIRECT("'c:\[doc" & A1 & ".xls]PLA'!$D$1"))

where cell A1 contains the value 200512 and on my c drive I have a file
called
doc200512.xls with a tab called PDA and numeric values in column D.

Can someone please show me how to make the files name up without having
to have the files acutally open?????

I have tried with the INDIRECT function but it only works when the
files are open.


I attached a screen shot where I tried the INDIRECT method.


Thanks


+-------------------------------------------------------------------+
|Filename: untitled.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4141 |
+-------------------------------------------------------------------+

--
southerndandy
------------------------------------------------------------------------
southerndandy's Profile: http://www.excelforum.com/member.php...o&userid=29806
View this thread: http://www.excelforum.com/showthread...hreadid=495147