Multiple sheet import
 

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

Multiple sheet import
 

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