| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving tabs into separte books
Hi There, I have a single excel File with 20 sheets. I want to move each sheet to a new book, so that I have 20 books (ie 20 Excel Files instead of one). Is there VB out there to achieve this...? Regards Darin *** Sent via Developersdex http://www.developersdex.com *** |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Saving tabs into separte books
hi Darin
See http://www.rondebruin.nl/copy6.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Darin Kramer" wrote in message ... Hi There, I have a single excel File with 20 sheets. I want to move each sheet to a new book, so that I have 20 books (ie 20 Excel Files instead of one). Is there VB out there to achieve this...? Regards Darin *** Sent via Developersdex http://www.developersdex.com *** |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saving Multiple Tabs as CSV | Excel Programming | |||
| saving 3 worksheets in a workbook to a separte workbook | Excel Programming | |||
| Seeing spreadsheets in separte monitors | Excel Discussion (Misc queries) | |||
| Separte columns for neg/pos values | Excel Worksheet Functions | |||
| Shared folder - tabs disappear while saving | Excel Worksheet Functions | |||
Hybrid Mode
