Sum same cell in many books

[Ron de Bruin]

Hi honyacker

You can create a Sum workbook with code.
See
http://www.rondebruin.nl/summary2.htm

 

[honyacker]

I want to create a new workbook that sums the cell H22 in every book that is
in a certain folder.
Is there a way to do this? This folder will have a new book added every day
..
Thanks,
joe

 

[honyacker]

Thanks Ron,
Looks like exactly what I am looking for.

joe

 

[honyacker]

Thanks Ron,
I'll give it a try.

joe