Thanks Ron,
I'll give it a try.

joe

"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