We are using Copy method of workbook to copy the worksheet. Here you can observe that we are copying the worksheet in the first statement. And Workbook2 is the destination sheet and sheets(1) and before key words tells Excel to copy the worksheet before the first sheet of workbook2. Workbook1 is your source workbook and Worksheet1 is your sheet to copy. Here workbooks can be ActiveWorkbook, ThisWorkbook or a workbook assigned to an object.ĪctiveWorkbook. WORKBOOK1.SHEETS(“WORKSHEET1).COPY BEFORE:= WORKBOOK2.SHEETS(1) We are using the Copy and SaveAs methods of the Excel Workbook object. This will help you to how to save a worksheet as New Workbook using VBA.įollowing is the VBA Syntax and sample VBA code to Save a Sheet as Workbook using VBA. Here is the Example VBA syntax and Example VBA code to save a Sheet as New Workbook. And this code should work for all the version of Microsoft Excel 2003, Excel 2007, Excel 2010, and Excel 2013. In this example we will see how to save Active Sheet and specific worksheet as new excel file using VBA. We can use Copy and SaveAs methods of Workbook to copy and save the sheet into new workbook.
VBA code to save sheet as Workbook example code will help us to save a specific sheet as new workbook.
0 kommentar(er)
