Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import work sheet? | New Users to Excel | |||
How to import multiple sheet of excel into Access database to a diffrent tables?? | Excel Discussion (Misc queries) | |||
Ref. problem after sheet import | Excel Programming | |||
Import into a Sheet module | Excel Programming | |||
Import CSV to 1 sheet | Excel Programming |