| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to save each sheet as a separate excel-file
En deze werkt ook ! Stukje korter zelfs. Dank !! "Ron de Bruin" wrote in news:#hFAyuv0DHA.2856 @TK2MSFTNGP09.phx.gbl: Try this Audio_freak Sub test() Application.ScreenUpdating = False For a = 1 To Worksheets.Count Sheets(a).Copy ActiveWorkbook.SaveAs Sheets(1).Name ActiveWorkbook.Close Next a Application.ScreenUpdating = True End Sub |
| Reply |
| 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 | |||
Hybrid Mode
