 |  |  |  |  |  |
| Course | Developing Microsoft Office 2000/XP 2002/2003 Using VBA | |
| Duration | 5 Days | |
| Overview | The primary objective of this course is to teach delegates how to develop custom solutions that integrate components of the Microsoft Office family. | |
| Content | Designing a Custom Solution | Microsoft
Office development features Office applications Developing with Office Sample custom solutions |
| Using the Visual Basic Editor | Where
code is stored Working with the Visual Basic editor Writing code, running and reusing code Getting help from the Object Browser |
|
| Using Visual Basic for Applications | Variables Procedures Controlling program execution Errors Debugging |
|
| Using Forms and Controls | Using
controls on forms Working with forms Using controls on documents |
|
| Object Models and Automation | Navigating
an object hierarchy Working with objects Automating Microsoft Office applications |
|
| Using Microsoft Excel Objects | Using
workbooks Using worksheets Creating charts Creating Pivot Table dynamic views |
|
| Using Microsoft Word Objects | Navigating
the Word object model Using events in Word Working with Word documents, areas of a document, with text and with Word forms Using Mail Merge |
|
| Using Microsoft PowerPoint Objects | Working
with presentations Working with slides Working with a slide show |
|
| Using Microsoft Access Objects | Introduction to programming with
Microsoft Access Using forms Using reports Using recordsets Microsoft Jet databases ODBCDirect Workspace |
|
| Using Shared Objects | Customising
menus and toolbars Programming the Assistant Searching for files Drawing objects |
|
| Using Microsoft Outlook Objects | Designing
forms in the Outlook desktop information manager Automating with Outlook |
|
| Adding Intranet Features | Working
with hyperlinks Saving documents in hypertext markup language (HTML) format Using the WebBrowser control |
|
| Distributing a Custom Solution | Securing
your custom solution Working add-ins Using references |
|