Microsoft Office Tutorials and References
In Depth Information
Chapter 1: Automation with Other Office Programs
Chapter 1: Automation with Other
In This Chapter
✓ Getting up to speed on Automation
✓ Working with Object Libraries
✓ Adding a contact to Outlook
✓ Merging data with a Word document
✓ Exporting data to Excel
In Book VIII, we show you Visual Basic for Applications (VBA) and present
some of the wonderful ways you can take control of your Access
database. You can use VBA to open and close forms, print reports, loop through
tables and change data, and modify form properties.
Well, VBA isn’t there just for Access. You can also use VBA to control other
Microsoft Office applications, including Outlook, Excel, Word, and PowerPoint.
With VBA, the possibilities are virtually endless when you consider what
some advanced users do in these Office applications on a daily basis. This
chapter explains Automation and gives several examples of how Access can
interact with other Office programs.
Automation (with a lowercase came about during the Industrial Revolution a)
to replace tasks performed by humans with faster, more efficient methods.
Phone operators no longer plug and unplug wires manually to make
connections; large systems handle connections automatically. People don’t do all
the work of assembling cars on assembly lines; industrial robots now handle
the bulk of the duties. We humans just get in the way.
In the world of VBA, Automation (with a capital refers to the capability A)
of a program to expose itself (make itself available) to VBA so that VBA can
control it behind the scenes, with little or no human interaction. Humans
just slow the process anyway. Other programming languages (such as VB.NET,
C++, and C#) use Automation as well, but because VBA is the language of
Access, we focus in this chapter on using VBA.