VBA SaveAs Workbook in Excel | A Complete Guide & Tutorial

VBA SaveAs Workbook is to Save changes to the workbook. And save workbook as a different Workbook file using SaveAs method of Workbook object. Workbook is a part of workbooks collection.

Table of Contents:

Objective
Syntax for SaveAs Workbook Method
Macro to Save Workbook as Different Workbook in Excel VBA
Instructions to Run VBA Macro Code
Other Useful Resources

Syntax for SaveAs Workbook Method

Here is the following syntax to SaveAs Workbook.

expression.SaveAs([FileName], [FileFormat], [Password], [WriteResPassword], _
    [ReadOnlyRecommended], [CreateBackup], [AccessMode As XlSaveAsAccessMode = xlNoChange], _
    [ConflictResolution], [AddToMru], [TextCodepage], [TextVisualLayout], [Local])

Where expression is a required parameter. It represents Workbook object which is part of workbooks collection.
All other parameters are optional parameters.

Macro to Save Workbook as Different Workbook in Excel VBA

Let us see the following example. It Saves workbook as a different Workbook file.

'VBA SaveAs Workbook in Excel
Sub VBA_SaveAs_Workbook()

    'Variable declaration
    Dim oWorkbook As Object
    
    'Create new workbook
    Set oWorkbook = Workbooks.Add
    
    'Save Workbook as different Workbook file
    ActiveWorkbook.SaveAs Filename:="D:\VBAF1\New_File.xlsx"

End Sub