Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Convert excel worksheets into new workbooks (new files)
I have an excel file that contains 80 worksheets. I want to automatically
convert each worksheet into own new excel file. How can I do that without copying and pasting? |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
Convert excel worksheets into new workbooks (new files)
Maybe some sort of macro:
Option Explicit Sub testme() Dim wks As Worksheet For Each wks In ActiveWorkbook.Worksheets wks.Copy 'to a new workbook With ActiveSheet .Parent.SaveAs Filename:="C:\temp\" & .Name, _ FileFormat:=xlWorkbookNormal .Parent.Close savechanges:=False End With Next wks End Sub Make sure C:\temp\ already exists (or change the code to point at an existing folder) G wrote: I have an excel file that contains 80 worksheets. I want to automatically convert each worksheet into own new excel file. How can I do that without copying and pasting? -- Dave Peterson |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
Convert excel worksheets into new workbooks (new files)
Thanks Dave!! I appreciate your quick response! I tested the script and it
works!! "Dave Peterson" wrote: Maybe some sort of macro: Option Explicit Sub testme() Dim wks As Worksheet For Each wks In ActiveWorkbook.Worksheets wks.Copy 'to a new workbook With ActiveSheet .Parent.SaveAs Filename:="C:\temp\" & .Name, _ FileFormat:=xlWorkbookNormal .Parent.Close savechanges:=False End With Next wks End Sub Make sure C:\temp\ already exists (or change the code to point at an existing folder) G wrote: I have an excel file that contains 80 worksheets. I want to automatically convert each worksheet into own new excel file. How can I do that without copying and pasting? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
How do I View & print or convert to PDF xls files without excel. | Excel Discussion (Misc queries) | |||
How do I convert PDF files to Excel? | Excel Discussion (Misc queries) | |||
how i convert excel files with images to access | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) |