Excel VBA Application object is the one of the most frequently used object while automating any task with VBA. We refer different Excel applications and perform various operations on Excel Workbooks. We have different Properties, Methods to deal with Excel Application Object. Here you can find a brief explanation about each on most useful Properties and Methods while automating any task.
Our objective of building this Excel VBA Explorer is to provide suitable examples on most frequently used methods and properties of Application object. So that you can quickly find the solution, syntax whenever you required it.
Application Object refers the entire Microsoft Excel Application. We can use Application Object to deal with Methods and Properties of the Entire Excel Application. Here are some Examples:
Application.WindowState = xlMaximized
Application methods helps us to perform different actions with Excel Workbooks. For example, we can Run a Application and Stop a Application ,etc.
Excel VBA Application Object Methods
- Calculate: To Calculate all Open Workbook.
- CalculateFull: To forces full caluculation in all the open Workbook.
- FindFile: To display open dialog box to open a file.
- Goto: To select any range.
- Run: To run a procedure or function.
- Wait: To stop running macro.
Properties of Application object will helps us to deal with various properties of Excel Applications. For example, we can change the Application Caption, sets the user name,sets the window state of the Application, etc.
Excel VBA Application Object Properties