Using the VSTA Manager

[Windows® version only]

[Windows® version only]

Use the VSTAManager toolbar to record, edit, and run Microsoft® Visual Studio Tools for Applications (VSTA) macros.

Macros let you perform tasks repeatedly and automate command sequences.

Macros are created by using the built-in features for VSTA.

You do not need programming experience to use macros. To create advanced macros, you can use the VSTA integreated development environment. Currently VSTA version 2.0 is supported.

To open the VSTA Manager toolbar:

• Click Tools > VSTA Manager (or type VSTAManager).

To record macros:

1. Click Record macro (VSTA Manager toolbar).
2. Run the commands to record.
3. Click Stop recording (VSTA Manager toolbar).

   Macro recording ends.

To run macros:

1. Select a macro on the VSTA Manager toolbar.
2. Click Play macro (VSTA Manager toolbar).

   The macro runs.

To edit macros:

1. Select a macro on the VSTA Manager toolbar.
2. Click Launch editor (VSTA Manager toolbar).

   Microsoft Visual Studio Tools for Applications 2.0 opens and displays the recorded macro code.

3. Edit the macro code.

To delete a macro:

1. Click Delete macro (VSTA Manager toolbar).
2. Type the name of the macro to delete.
3. Click Yes to confirm the deletion.

Access

Command: VSTAManager

Menu: Tools > VSTA Manager