REAL-TIME

VBA Projects

Full Access with Source Code
  • Designed and Developed by PNRao

  • Full Access with VBA Source Code

  • Well Commented Codes Lines

  • Creative and Professional Design

Effortlessly
Manage Your Projects

120+ Project Management Templates

Seamlessly manage your projects with our powerful & multi-purpose templates for project management.

120+ PM Templates Includes:
  • 50+ Excel Templates

  • 50+ PowerPoint Templates

  • 25+ Word Templates

Share Post

We can close workbook by using ‘Close method of workbook object in Excel VBA. It closes the workbook object. Please find the following brief description about close method of workbook object.

VBA Close Method Excel Workbook Object

Why we need to Close a Workbook using VBA?

Once we perform the tasks in Excel Workbook, we need to close the workbook. And the whenever we want we can reopen Workbook again.

VBA Close Workbook – Syntax

Here is the syntax to close workbook using VBA.

Workbooks(“Your Workbook Name”).Close(

[SaveChanges], [Filename], [RouteWorkbook])

In the above syntax we are using ‘Close’ method of workbook object to close the workbook.

VBA Close Workbook: Example 1

Please find the below example, It will take you through to close workbook where SaveChanges:=True.

Sub Close_Workbook()

    Dim Wkb As Workbook
    Set Wkb = Workbooks.Open("D:Sample.xlsx")
    Wkb.Close Savechanges:=True
    
End Sub

Explanation:

In the above example we have created variable named Wkb in the first statement. We have used Open method of workbook object to open specified workbook named ‘D:Sample.xlsx’ and then assigned it to object named Wkb in the second statement. At last in the third statement we have used ‘Close’ method of workbook object to close above specified workbook. Finally we have mentioned ‘Savechanges:=True’, that means if we have done any changes in the worksheet it will save the changes.

VBA Close Workbook: Example 2

Please find the below example to close workbook where SaveChanges:=False.

Sub Close_Workbook()
    Workbooks (“ D:Sample.xlsx").Close Savechanges:=False    
End Sub

Explanation:

The above example is same as like example 1 which we explained in the above. The difference is we have mentioned ‘Savechanges:=False, that means if we made any changes in the worksheet it discards any changes that have been made to it.

VBA Close Workbook: Example 3

Please find the below example to close workbook where SaveChanges:=False.

Sub Close_Workbook()
    ActiveWorkbook.Close    
End Sub

Explanation:

The above mentioned code closes the active workbook.

VBA Close Workbook – Instructions

Please follow the below step by step instructions to execute the above mentioned VBA macros or codes:

  1. Open an Excel Workbook
  2. Press Alt+F11 to Open VBA Editor
  3. Insert a Module from Insert Menu
  4. Copy the above code for activating a range and Paste in the code window(VBA Editor)
  5. Save the file as macro enabled workbook
  6. Press ‘F5’ to run it or Keep Pressing ‘F8’ to debug the code line by line.
Effortlessly Manage Your Projects and Resources
120+ Professional Project Management Templates!

A Powerful & Multi-purpose Templates for project management. Now seamlessly manage your projects, tasks, meetings, presentations, teams, customers, stakeholders and time. This page describes all the amazing new features and options that come with our premium templates.

Save Up to 85% LIMITED TIME OFFER
Project Management Templates

All-in-One Pack
120+ Project Management Templates

Essential Pack
50+ PM Templates

Excel Pack
50+ Excel PM Templates

PowerPoint Pack
50+ Excel PM Templates

MS Word Pack
25+ Word PM Templates

Ultimate Project
Management Template
Ultimate Resource
Management Template
Project Portfolio
Management Templates
Last Updated: March 2, 2023

Leave A Comment