Scribd
Upload
172 views1 page

Excel VBA Object Model Overview

The document describes the Excel VBA object model, including the Application, Workbook, and Worksheet objects. The Application object contains properties like Version and Caption and methods like Calculate and Quit. The Workbook object has properties like Name and Saved and methods like Close and Save. The Worksheet object contains properties like Name and Visible and methods like Copy, Delete, and Activate.

Uploaded by

Owain Evans
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
172 views1 page

Excel VBA Object Model Overview

The document describes the Excel VBA object model, including the Application, Workbook, and Worksheet objects. The Application object contains properties like Version and Caption and methods like Calculate and Quit. The Workbook object has properties like Name and Saved and methods like Close and Save. The Worksheet object contains properties like Name and Visible and methods like Copy, Delete, and Activate.

Uploaded by

Owain Evans
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Excel VBA Object Model

Application Object

Properties Methods Events

Version Caption Default file path Workbooks collection Calculate CheckSpelling Quit SheetCalculate NewWorkbook WorkbookBeforeClose

Workbook Object

Properties Methods Events

Name Sheets Saved Close PrintOut Save BeforeClose NewSheet BeforeSave

Worksheet(s) Object

Properties Methods Events

Name UsedRange Visible Active Copy Delete Activate Deactivate Change

You might also like