Excel — Save Sheet to New Workbook Example This is a very useful application for saving or copying sheet in an app. It will save the sheets without opening any of the workbooks. The If it's the case, then it is very useful for saving sheets to the new workbook. VBA Save Workbook As New Workbook May 31, 2024 — This VBA It uses a very clever way to save Workbook. It saves the workbook as a workbook named as workbookName. Now it saves the same way. But when you use Copy or Save As, it copies a new workbook instead of copy the old workbook. This is how you can use this application to save your workbook to a new workbook. Steps: Step 1 Step 1 — Import a VBA Module Step 2 Step 2 — Declare an object Variable VBA: Import Module to Excel Macro Example Step 3 In this procedure, you can import VBA Script module to a worksheet. You can use any module as a module to save sheet as a workbook, save for example a sheet named as New workbook. Step 4 Step 4 Step 4 — Declare a macro variable from the Macro Example Step 5 Step 5 Step 6 Step 6 — Use Copy and Saves Method Step 7 Save Sheet as New Workbook Step 7 — Step 7 — I save the sheet to New Workbook as the sheet Name is Sheena. VBA: Save Workbook As New Workbook Macro example using VBA Now I have saved all the workbook as a new workbook (mynewworkbook.xls file) using this workbook. If we go to Visual Basic Editor, we will see a new workbook named as Mynewworkbook in the Workbook menu. We can use Excel Ribbon and Excel Workbook to open the new workbook. When we open it, we will see a new window named as New Workbook and a new sheet named as New sheet. The name of Sheet is Sheena. Next, we can use Excel Ribbon, to select the New Sheet and type the name of the file as “sheetName.zip”. The next step is to open the zip and save it as mynewworkbook.zip. This file will create the folder on the Desktop.