For Dummies Access 2010 All-in-One 978-0-470-53218-8 Manuale Utente
Codici prodotto
978-0-470-53218-8
Chapter 1: Automation with
Other Office Programs
Other Office Programs
In This Chapter
✓
Understanding Automation
✓
Adding a contact to Microsoft Outlook
✓
Merging data with a Word document
✓
Exporting data to Excel
I
n Book VIII, we show you VBA (Visual Basic for Applications) and give
you an understanding of some of the wonderful ways you can take con-
you an understanding of some of the wonderful ways you can take con-
trol 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.
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 con-
sider 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 these other Office programs.
other Microsoft Office applications including Outlook, Excel, Word, and
PowerPoint. With VBA, the possibilities are virtually endless when you con-
sider 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 these other Office programs.
What Is Automation?
Automation came about during the industrial revolution to replace tasks
performed by humans with faster, more efficient methods. Instead of phone
operators manually plugging and unplugging wires to make a connection,
large systems handle this automatically. Rather than having people assem-
ble cars on the assembly line, industrial robots now handle the bulk of the
duties. Us humans just get in the way.
performed by humans with faster, more efficient methods. Instead of phone
operators manually plugging and unplugging wires to make a connection,
large systems handle this automatically. Rather than having people assem-
ble cars on the assembly line, industrial robots now handle the bulk of the
duties. Us humans just get in the way.
In the world of VBA, Automation (with a capital A) refers to the ability of
a program to expose itself to VBA so that VBA can control it behind the
scenes, with little or no human interaction. Humans just slow down the
process anyway. Other programming languages such as C++ and C# use
Automation as well, but since VBA is the language of Access, we focus on
using VBA.
a program to expose itself to VBA so that VBA can control it behind the
scenes, with little or no human interaction. Humans just slow down the
process anyway. Other programming languages such as C++ and C# use
Automation as well, but since VBA is the language of Access, we focus on
using VBA.
44_532188-bk09ch01.indd 665
44_532188-bk09ch01.indd 665
3/29/10 10:59 PM
3/29/10 10:59 PM
COPYRIGHTED MATERIAL