Excel VBA Workbook Object

The Excel VBA Workbook object in VBA represents a workbook in Excel. The Open, Close, Save, Saveas, Activate and Export to PDF etc. are some of the methods that you can use with the Workbook object:

Workbook Open Method examples

Sub workbook_open_method()
'Workbooks.Open ""C:\Users\Shantilal\Desktop\WBOM\information.xlsx"
Workbooks.Open Filename:="C:\Users\Shantilal\Desktop\WBOM\information.xlsx"
End Sub

Sub get_dialogbox()
Application.GetOpenFilename ' dialogbox open
End Sub

Sub workbook_open_password()
Workbooks.Open Filename:="C:\Users\Shantilal\Desktop\WBOM\information.xlsx", Password:="abc"
End Sub


Sub workbook_open_readonly()
Workbooks.Open Filename:="C:\Users\Shantilal\Desktop\WBOM\information.xlsx", ReadOnly:=True, Password:="abc"
End Sub


Sub workbook_close_method()
'Workbooks("Information").Close
'Workbooks("Information").Close savechanges:=True

End Sub

Workbook Save and Saveas Methods

Sub create_newfile()
'Workbooks.Add
Workbooks.Add.Save ' save to default location that is mydocument having default name i.e. book1/book2
End Sub

Sub save_file()
Workbooks("Book1").Save ' save without macros
End Sub

Sub saveas_file()
Workbooks("book1").SaveAs Filename:="C:\Users\Shantilal\Desktop\dataddf\book1", FileFormat:=52, CreateBackup:=True
End Sub

Sub saveascopy()
Workbooks("book1").SaveCopyAs Filename:="C:UsersShantilalDesktop\dataddfdr\book1.xlsm"
End Sub

Workbook Export to pdf methods

Sub test()
ActiveSheet.ExportAsFixedFormat _
    Type:=xlTypePDF, _
    Filename:="C:\Users\Shantilal\Desktop\datass", _
    Quality:=xlQualityStandard, _
    IncludeDocProperties:=False, _
    IgnorePrintAreas:=False, _
    From:=1, _
    To:=5, _
    OpenAfterPublish:=True

End Sub

Sub export_file()
ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF
End Sub


Sub export_file_location()
ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:="C:\Users\Shantilal\Desktop\datasees"
End Sub

Scroll to Top