| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
saving 3 worksheets in a workbook to a separte workbook
I'm using Excel 2003 and I want use vba to save 3 of the sheets in a workbook
to a new workbook with a new name generated each time. I can save one but I can't figure out how to save three. For example, I want to copy three sheets named temp1, temp2, and temp3 to a new workbook created and named in the original workbook, so that workbook 2 will contain only copies of sheets, temp1, temp2, and temp3. Any help will be greatly appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine worksheets in multiple workbook in one workbook with a macro | Excel Discussion (Misc queries) | |||
| Color Changes When Saving 2007 Workbook as 97 - 2003 Workbook | Excel Discussion (Misc queries) | |||
| Saving a Workbook where the worksheets are protected | Excel Worksheet Functions | |||
| copying worksheets to a new workbook without formulae referencing original workbook | Excel Programming | |||
| Saving a sheet in a workbook as .csv but not changing workbook name | Excel Programming | |||
Threaded Mode
