Save and close an Excel workbook

How to save and close a workbook using VBA

VBA

Sub Save_and_Close_Workbook()

'save and close a workbook

ThisWorkbook.Close savechanges:=True

End Sub

ADDITIONAL NOTES
Note 1: This code will save and close the workbook in which the VBA code is written in.

EXPLANATION

EXPLANATION
This tutorial explains and provides step by step instructions on how to save and close a workbook using VBA.

The VBA code that is provided in this tutorial will save and close a workbook in which the VBA code is written in.

RELATED TOPICS

Related Topic	Description	Related Topic and Description
Open an Excel workbook	How to open a single workbook using Excel, VBA and Shortcut methods
Close an Excel workbook	How to close a single workbook using Excel, VBA and Shortcut methods
Save Excel workbook without being prompted	How to save an Excel workbook without being prompted using VBA
Open an Excel workbook as Read-Only	How to open a single workbook as Read-Only using Excel and VBA methods
Save an Excel workbook	How to save a workbook using Excel, VBA and Shortcut methods