| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
building new workbook from sheets in different workbooks
Hi,
can anyone help, please? I've 5 workbooks, each containing the sheets A-Z (Customernames). Now I need a macro that goes into each of the workbooks, selects all sheets with name "A" and saves it as new file "A", then goes back and continues with sheet "B" and so on. Anyone an idea? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Merging workbooks into different sheets in a different workbook | Excel Discussion (Misc queries) | |||
| building chart from multiple sheets | Charts and Charting in Excel | |||
| building several workbooks from several workbooks | Excel Discussion (Misc queries) | |||
| Printer error building Excel workbook...? | Excel Programming | |||
| How do you list all the workbooks you have opened and the sheets in each workbook? | Excel Programming | |||
![chris[_15_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
