Close Method of Workbook Object VBA

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.

PREMIUM TEMPLATES LIMITED TIME OFFER

ON SALE80% OFF

50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates


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.
LIMITED TIME OFFER

Leave A Comment


Related pages


multiple project timeline template excelvbscript output to text fileexcel vba ribbonvba examples excelhow to create vlookup in excel 2007can you merge cells in excellookup formulahow to add the developer tab to the ribbonhow to order alphabetically in excelaccess vba msgboxaverage function in excel 2013create macros excelpassword vba excelhow to do pivot table in excel 2010project milestone template pptdynamic array excelvba excel substitutevba line feed characterexcel developer tab 2013writing macros in wordvba code for vlookuphyperlink shortcut keyadvantages of ms excelexcel vlookup practiceuseful excel sheetsmicrosoft excel autofitconnection string vbavba excel templatesexcel macro string concatenationvba delete rowsexcel sumif exampleaccess vba input boxaccess messageboxvba data entryexcel rgb colorloop vba excelsqlfunctionsdim vbaexcel pull data from another sheetunhide access tabledefinition of merge in excelxml to excel conversionfind unique values in excel 2010delete duplicate datavba copy folderbeautiful excel dashboardssendmail subjectsave xls as xmlvba code to open excel filewhat is hlookup in excel used fordelete sheet in excelstudy schedule template excelexcel vba sql connection stringmerge cell in excelexcel project budget templatelearn excel torrentmacro to combine worksheetsidentify duplicates excelhow to hide cells in excellcombine data from multiple worksheetsuse of concatenate in excelascending order on excelhow to add a chart title in excelpmo templates excelsql tutorials for beginnerssumif on excelhow to open xlsx file in excel 2003how to analyse trends in excelexcel 2013 pivot table tutorialexcel dynamic chartstutorial on macros in excelvba upper caserisk dashboard template excelremove blank cells in excel formularemove protection from excel 2010 without passwordhow to vlookup in excel 2007 with examplevba excel addressmeaning of vlookup and hlookupinsert blank rows in excel