Hi Bill,

See Ron de Bruin's sample code at:

http://www.rondebruin.nl/ado.htm

and

http://www.rondebruin.nl/copy7.htm

See also Ro's index page at:

http://www.rondebruin.nl/tips.htm


---
Regards,
Norman



"Bill" wrote in message
k.net...
Hello All,
I would like to open each workbook in a folder, get some information from
it and close it. How can that be done? I can get the path but when I do
workbooks count, it just counts the open workbooks.

Thanks,

Bill