In this course, you will learn to:
- Learn about the Object Browser and online Help-the tools you’ll need to figure out any product’s object model.
- Find out how to determine what objects the user is working with when your code runs.
- Get familiar with the techniques you’ll need to create solutions that use the features of more than one product.
- Learn how to use combo boxes and list boxes in the forms you create.
- Find out how to open a table in a database to read and change its records.
- Explore different techniques you can use to add data to an Excel workbook.
- Learn how to create charts from code using information in Excel or the result of a database query.
- Find out how to get information from Word documents to create new documents or PowerPoint presentations.
- See how you can automatically send an Outlook e-mail message while you’re working in Excel or Word.
To get the most out of VBA Solutions for Microsoft Office, you must understand basic programming concepts such as control structures, looping structures, and variables. You must also be familiar with creating simple procedures in any VBA host, such as Microsoft Access, Microsoft Excel, Microsoft PowerPoint, or Microsoft Word.