summing from arbitrary list of workbooks

[Don H]

Does anyone know how to state a function that sums the
same cell in a list of workbooks, where that list may vary
from time to time?

What I really would like is to be able to use a reference
such as =SUM([*.xls]A15) and have that sum the cell from
any spreadsheets in the current directory. This
particular syntax, though, is not valid.

I could build a macro that searched the directory, and
then built the necessary function arguments, cell by cell,
but this is both inelegant and a drag to do.

Anyone have any clever solutions? Thanks
-don

 

[Frank Kabel]

Hi Don
AFAIK not possible without using VBA if the other workbooks could be
closed

 

[Guest]

Thanks for your reply, Frank... I'm afraid you're probably
right, but still maintain a speck of hope that someone out
there may know of some clever solution.
-don

-----Original Message-----
Hi Don
AFAIK not possible without using VBA if the other workbooks could be
closed

--
Regards
Frank Kabel
Frankfurt, Germany

Does anyone know how to state a function that sums the
same cell in a list of workbooks, where that list may vary
from time to time?

What I really would like is to be able to use a reference
such as =SUM([*.xls]A15) and have that sum the cell from
any spreadsheets in the current directory. This
particular syntax, though, is not valid.

I could build a macro that searched the directory, and
then built the necessary function arguments, cell by cell,
but this is both inelegant and a drag to do.

Anyone have any clever solutions? Thanks
-don

.