Excel VBA Objects: Application Object

Welcome to the Excel VBA Objects Series. In this video we'll see how to work with the Application object and get the most of it. We can use properties and methods of the Application object in Excel VBA to get or set information about the application itself, show or hide components of the application interface, enable or disable displaying certain alerts and notifications, launching a dialog box to pick files, folders, open or save files, and much more. We will see all that in this video. In the next video we will cover Application events, including methods to respond to some external events, and also event procedures at the application level.

The following videos in the series are going to focus on other Excel VBA objects individually. Among these we will see the Application object, the Workbook object, the Sheets and Worksheet objects, the WorksheetFunction object, the Range object, the Shape object, and the Chart object.

And yet, if you want more, you can find various Excel templates, dashboards, and applications of different nature in the other blogs of the Excel Macro Mania saga:

[muhammadrashid]

Very useful.. Thanks a lot
Sir I want to confirm the news about vba support from Microsoft is ending soon????

[umeshsai]

Hello Sir, thank you for the video. Jus wanted to know that how did you able to convert the entire code to text by adding apostrophe " ' " before to the code. Thanks in advance for your assistance

[bounsanongvongphachanh]

How about to disable or hide some manu
On print preview mode leave only print buttom