About this Course
This four-day instructor-led course provides students with the knowledge and skills to use VB programming in excel sheet.
Course Outline
| • |
Introduction |
| o Macro Introduction and Recording Macro o VBA Introduction and Exploring Visual Basic Editor o Variables, Arrays, Constants and Data Types o Modules, Functions and Subroutines o Decisions and Looping o Strings, Built-In Functions and Message Boxes o Operators o Debugging o Errors, Handling Errors and Error Functions o Dialogs o Common Dialog Control o Command Bars and Buttons |
|
| • | Excel Object Models |
| o Excel Object Model o Objects, Properties and Methods o Exploring Object Browser o Object Hierarchy o Recording Macros |
|
| • | Excel Object Model – Main Objects |
| o Application Object o Workbook Object o Windows Object o Worksheet Object o Range Object |
|
| • | Using Excel to Do Interaction with Other Office Application |
| o Interaction with Microsoft Outlook o Driving Excel from Other Office Application |
|
| • | Excel VBA Advanced Technique |
| o Working with Charts and Graphs o Working with Series Collection Object o Exporting a Chart as Picture File o Using Macro Recording o Working with Databases o ODBC Links o Using ADO |
|
| • | API Calls |
| o API Call Basics o Using API Call |
|
| • | Class Modules |
| o Inserting Class module o Create an Object o Creating a Collection o Using PNames Collection |
|
| • | Working with XML Files |
| o XML Document Basics o How does XML Relate to VBA o XML Map Basics o Customizing XML Map o Importing and Exporting Data o Manipulating XML Files Programmatically |
|
| • | Ribbon |
| o Creating a Ribbon Customization o Using Custom UI Editor o Creating Code for Your Custom Buttons o Images o Using VBA Code with the Ribbon o More on Ribbon |
|
| • | Pivot Tables |
| o Creating a Simple Pivot Table from the Front End of Excel o Creating Pivot Table Using VBA o Using VBA with Pivot Table o Advanced VBA for Pivot Tables o Points to Bear in Mind on Pivot Tables |
