See this page for code examples
http://www.rondebruin.nl/copy3.htm

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



"John" wrote in message ...
I want to gather up about 80-100 workbooks into one workbook. Each workbook has only one sheet. Is there a handy way of doing this?
Like "import" and then select all 60 or something? The workbooks are named by dates in the form 05-05-2006.xls etc. They are
records of billing on that date. I want a billing workbook instead of separate sheets.

I am using office 2003 excel. I can't find ANY import function on the toolbars which leaves me opening each file and exporting it
to the new workbook.

Thanks

John