| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to save each sheet as a separate excel-file
Hi, Happy New Year Could anybody assist me with the code for saving each sheet to a separate (newly created) file? So that if I have an excel-file with 20 sheets, I would like a macro to create 20 separate files. The new files could get the same names as the sheets (preferably) or the names could be taken from a cell in the relevant sheet. Thanks for any help you can give. Peter |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Split text file into Excel sheet and separate the final results intoa new sheet | Excel Worksheet Functions | |||
| How do I save a page in a workbook as a separate file? | Excel Worksheet Functions | |||
| How do I save part of a worksheet in a separate file? | Excel Worksheet Functions | |||
| Can I auto save to a separate file?(not the file I am working in) | Setting up and Configuration of Excel | |||
| Excel kept on asking to save file every time I jump from one sheet to another! | Excel Worksheet Functions | |||
Threaded Mode
