Hi Marcotte

I have examples on my webpage
http://www.rondebruin.nl/tips.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Marcotte A" wrote in message
...
I have daily production workbooks that I need to combine into a monthly
total
workbook. They each have the same layout/format etc. I just need to step
through each workbook in a directory and add the numbers to the monthly
total
workbook. Is it possible to use a for...each loop? If so, what is the
correct syntax?

eg...

dim wkb as workbook
for each wkb in <Path
wkb.open
'add numbers to ThisWorkbook
wkb.close
next wkb

where <Path is the same directory as ThisWorkbook (which contains the
code)