Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exporting from worksheets into new workbooks
I have written the following code, which when run, I want to go through all
the sheets in my workbook and and copy and paste the data from these sheets into new workbooks. Unfortunatly the code below will cause the data from the same worksheet to be copied into new workbooks, Can anyone help Sub sheetexport() Dim sheet_var As Worksheet For Each sheet_var In ActiveWorkbook.Worksheets Cells.Copy Workbooks.Add Application.ScreenUpdating = False Selection.PasteSpecial Paste:=xlPasteValues Selection.PasteSpecial Paste:=xlPasteFormats Next End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exporting from worksheets into new workbooks
Hi nir020
Use this example http://www.rondebruin.nl/copy6.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "nir020" wrote in message ... I have written the following code, which when run, I want to go through all the sheets in my workbook and and copy and paste the data from these sheets into new workbooks. Unfortunatly the code below will cause the data from the same worksheet to be copied into new workbooks, Can anyone help Sub sheetexport() Dim sheet_var As Worksheet For Each sheet_var In ActiveWorkbook.Worksheets Cells.Copy Workbooks.Add Application.ScreenUpdating = False Selection.PasteSpecial Paste:=xlPasteValues Selection.PasteSpecial Paste:=xlPasteFormats Next End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy/ move selected data from workbooks to seperate worksheets or workbooks | Excel Worksheet Functions | |||
exporting data from Workbooks in Folder | Excel Programming | |||
Exporting the same Excel macro to 60 workbooks | Excel Programming | |||
Exporting multiple worksheets as CSV | Excel Programming | |||
Exporting multiple worksheets as CSV | Excel Programming |