Course Detail

Day 1: MS Office Object Hierarchies and the Object Browser

1. Objects, Collections, and Hierarchies.
2. Properties, Methods, and Events.
3. Using the Object Browser.
4. MS Office Application Reference Libraries.
5. Exercise I.

Day 2: Working within an MS Office Application

1. VBA or Macro Recorder.
2. Special Macros.
3. Object Variables.
4. Binding.
5. Application Object Examples.

Day 3: User Defined Types, Classes and Arrays

1. Introduction to User-Defined Types (UDTs).
2. Creating a User-Defined Type.
3. Creating a Class.
4. Creating Array Variables.
5. Using Arrays in Code.

Day 4: File and Folder Management using VBA

1. Using the File System Object.
2. Handling Folders using VBA.
3. Create a Folder.
4. Move, Rename, Copy or Delete a File.
5. File or Folder Properties and Attributes.

Day 5: Interaction between MS Office Applications

1. Classes.
2. References.
3. Working with Objects in another Application.
4. Editing Documents across MS Office.
5. Exercise II.

Day 6: Working with the Excel Range Object

1. Range Objects Defined.
2. Referencing Ranges using VBA.
3. Dynamic Range Handling.
4. Copying/Moving Range Data.
5. Importing Data from a Delimited File or Web Page.

Day 7: Working with Data in Excel

1. Excel and ADO.
2. Data Types or Formatting.
3. Validating Data.
4. Filtering and Sorting Data with VBA.
5. Using Worksheet Database Functions Excel Tables.

Day 8: Presenting Data in Excel

1. Apply Conditional Formatting with VBA.
2. Working with Charts.
3. Pivot Tables.

Day 9: Programming Access with VBA

1. Navigating the Access Object Hierarchy.
2. Understanding Access Collections.
3. Exercise III.

Day 10: Case-Study.

Language: English.

Place: London – UK.

Venue (TBC): Radisson Edwardian Sussex Hotel (Address: 19-25 Granville Place, Marylebone, London W1H 6PA – UK).