Automation Overview

The Automation Scripting API can be used with Mathcad 2001i and higher. It consists of a hierarchy of automation classes, each with their own properties, methods, and events. These classes allow you to:

• open and close Mathcad
• control the appearance of windows
• open, recalculate, save, and print worksheets
• retrieve information about regions
• assign and retrieve complex scalar variables, matrices, and strings

There are two top level objects which you can create by asking the system for a new instance of them. The Application class can be invoked by co-creating an instance of Mathcad.Application. Additionally, the Worksheet class can be invoked directly by co-creating an instance of Mathcad.Worksheet. Other objects can only be manipulated through these objects and their children: the Worksheet.Regions collection, for example, cannot be created on its own.

Classes and Collections

• Application class
• Worksheets Collection
• Worksheet class
• Worksheet2 class
• Window class
• Region class
• Region2 class
• NumericValue class
• StringValue class
• MatrixValue class

Examples

1. A Visual Basic program that displays a Windows form, allowing you to set an input variable, apply this value in a .mcd file, and return the results from the file.
2. An Excel Spreadsheet that allows you to highlight a row of data, feed those values into the correct entries in a Mathcad sheet, and return values from the sheet into new cells in Excel.