Extending product function with VBA : Automation and System Architect
  
Automation and System Architect
Automation enables an application to declare and use objects that are created by other application. By using Microsoft VBA, code may be written to access the objects of one or more of these application’s objects in a single program.
The use of automation provides the potential for a fully integrated solution to be built based around the functionality of a number of products. System Architect has Microsoft VBA embedded in it, allowing other applications to use its functionality. The following sections explain this functionality.
This section describes automation and how can it help provide a customizable solution, and how to set up System Architect to provide the functionality required for the solution.
See also
Automation
Customizable solutions
Planning an automated solution with System Architect
Automation of macro projects with VBE
Introduction to extending SA with VBA