Save an Excel workbook

How to save a workbook using Excel, VBA and Shortcut methods

METHOD 1. Save an Excel workbook using the ribbon option

EXCEL

File tab > Save

1. Select the File tab. Select File tab

2. Click Save. Click Save

METHOD 2. Save an Excel workbook using the Quick Access Toolbar

EXCEL

Click Save button in the Quick Access Toolbar

1. Scroll to the Quick Access Toolbar and click on the Save button. Click Save in Quick Access Toolbar

METHOD 1. Save an Excel workbook in which the VBA code is written

VBA

Sub Save_a_Workbook()
'save a workbook where this VBA code is written
ThisWorkbook.Save

End Sub

ADDITIONAL NOTES
Note 1: Using ThisWorkbook.Save will save the workbook in which the VBA code is written.

METHOD 2. Save a specific workbook

VBA

Sub Save_a_Specific_Workbook()
'save a workbook titled Examples.xlsx
Workbooks("Examples.xlsx").Save

End Sub

PREREQUISITES
Workbook Name: This example saves a workbook titled "Examples.xlsx", therefore if using the same VBA code you need to have a workbook titled "Examples.xlsx" open at the time of running this VBA code.
ADJUSTABLE PARAMETERS
Workbook Selection: Select the workbook that you want to save by changing the workbook name in the VBA code to any workbook that you want to save.

Save an Excel workbook

SHORTCUT

WINDOWS SHORTCUT

Ctrl
S

NOTES
The shortcut will save the current workbook.

Explanation about how to save a workbook

EXPLANATION

EXPLANATION
This tutorial explains and provides step by step instructions on how to save a workbook using Excel, VBA and Shortcut methods.

Excel Methods: This tutorial provides two Excel methods that can be applied to save a workbook. The first methods shows how to access the save function through the File tab, which is a two step process. The second method uses the save function in the Quick Access Toolbar, which is a one step process. The second method assumes that you have the save function in the Quick Access Toolbar.

VBA Methods: This tutorial provides two VBA methods that can be applied to save a workbook. Using the first VBA method you can save a workbook in which the VBA code is written in. Using the second VBA method you can save a specific workbook by referencing to an open workbook.

Shortcut Method: The Shortcut in this tutorial will instantly save the current workbook.

RELATED TOPICS

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