• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 21. Automating Other Applications > Talking to Excel from Access

Talking to Excel from Access

As you can see, the syntax for automation coding is not difficult to learn. You just set the appropriate reference and then use objects from the automation server just like native Access objects. The real learning curve in automation comes in discovering what you can do with other applications. If you’ve installed a reasonable amount of software on your computer, you probably have dozens or even hundreds of automation servers available.

We can’t possibly give you a comprehensive look at what all those applications can do via automation. Instead, we just show you a couple of examples, one using Microsoft Excel and the other using Microsoft Word.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint