| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I save each sheet as a separate .xls file by using macro?
I have a workbook that has 100 sheets. I want to save each sheet as a
separate xls file. Even though I could save each by copying into new worksheet and save manually, I am looking for a way to automate it by using script. Can anyone help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I get a macro to save a sheet and set the file name? | Excel Discussion (Misc queries) | |||
| 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 | |||
| How to save each sheet as a separate excel-file | Excel Programming | |||
| Macro to insert values from a file and save another sheet as a .txt file | Excel Programming | |||
Threaded Mode
