In this course you will learn the skills to enable you to use the Visual Basic for Applications (VBA) programming language to simplify or automate activities and tasks using the Microsoft Office 2007 - 2016 applications. The course covers examples in Excel, Access, Word and PowerPoint 2007 - 2016.
Please Note: Microsoft Excel 2013 is used as the primary application during the course for demonstration purposes.
Delegates looking to gain enhanced skills to apply VBA to develop macros to work with Office applications. You will work with the application object models, manipulate data across applications and manage files and folders using VBA.
Module 1 - MS Office Object Hierarchies and the Object Browser
Module 2 - Working within an MS Office Application
Module 3 - User Defined Types, Classes and Arrays
Module 4 - File and Folder Management using VBA
Module 5 - Interaction between MS Office Applications
Module 6 - Working with the Excel Range Object
Module 7 - Working with Data in Excel
Module 8 - Presenting Data in Excel
Module 9 - Programming Access with VBA
Join our public courses in our Istanbul, London and Ankara facilities. Private class trainings will be organized at the location of your preference, according to your schedule.