VBA and Express Macros

In InfoConnect, you can create and run macros to simplify and automate routine tasks. You can create two types of macros:

Visual Basic for Applications (VBA) macros

Create VBA macros when you want to interact with multiple sessions or external applications, such as Microsoft Excel. You can record VBA macros or create them in the Visual Basic editor. You don't need to know how to program to record and playback a macro but recorded macros have limitations (for example, you cannot record interaction with other applications or Web sites).

To create complex macros that perform InfoConnect actions and interact with other applications, you'll need to use the Visual Basic Editor. A common approach for creating a macro is to record it and then fine-tune it using the editor. For more information about editing and programming macros, see the InfoConnect VBA Guide ( Help > VBA Guide ).

Express Macro Language (EML) macros

Create an Express macro when you need to automate basic tasks but are not familiar with programming or when you want to run the macro in other Rocket Software products. Express macros can be used to automate basic tasks that apply to only one session. They cannot interact with other sessions or external applications. After you create and save an Express macro, you can run it in other Rocket Software products.

You do not need to know anything about programming syntax to create an Express macro. You can record macros or you can use the Express visual programming editor. Using this editor, you can create or edit macros by arranging graphical elements that represent code blocks rather than specifying them textually.

Running macros with the Macro Panel

You can use the Macro Panel to run VBA macros saved in your session document file or to run other macros, such as referenced macros, EML macros, or macros created with other products, that you have previously run on that session. The Macro Panel is a convenient way to keep track of and run macros that apply to a session without adding buttons to the ribbon. It displays only the macros that apply to the session that has focus.

The Macro Panel has three tabs:

The Available tab shows the VBA macros that are saved in the session document file.

The Recent tab shows all macros that you have previously run in this session. This includes VBA macros as well as other supported macros that you have run, such as EML macros or macros created with other products.

The Favorites tab shows the all the macros that you have marked as favorites.

More information

• Creating, Editing, and Running Express Macros

• Creating and Using VBA Macros

• Extra Macros

• CASL Macros

• NET API

• IHLLAPI