Hi honyacker
You can create a Sum workbook with code.
See
http://www.rondebruin.nl/summary2.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl
"honyacker" wrote in message ...
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