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