Working with Workbooks All workbooks are contained in the open Any member can be Workbooks collection. specified with its name: Ex: Workbooks(“Cougs.xlsm”) Opening a Workbook To open a workbook, use the Open method and type out the full path (note both the and equals sign with no spacing after Filename): Ex: Workbooks.Open Filename:=“C:\My Documents\Cougs.xlsm” Closing a Workbook To close a workbook, use the Close method: Workbooks(“Cougs.xlsm”).Close Name Display To display the name of the active workbook: Ex: ActiveWorkbook.Name Saving a Workbook To save using the current name and format, use the Save method: Ex: ActiveWorkbook.Save
Working with Workbooks All open workbooks are contained in the Workbooks collection. Any member can be specified with its name: Ex: Workbooks(“Cougs.xlsm”) Opening a Workbook To open a workbook, use the Open method and type out the full path (note both the and equals sign with no spacing after Filename): Ex: Workbooks.Open Filename:=“C:\My Documents\Cougs.xlsm” Closing a Workbook To close a workbook, use the Close method: Workbooks(“Cougs.xlsm”).Close Name Display To display the name of the active workbook: Ex: ActiveWorkbook.Name Saving a Workbook To save using the current name and format, use the Save method: Ex: ActiveWorkbook.Save
MgtOp-556-Topic-1-Set-4.docx