The process of creating a macro begins with creating a macro project. A macro project can be created in one of two ways:
Using GMS files
For best results in storing and distributing a macro project, it is highly recommended that you use a GMS file. GMS files are stored in the GMS folder for the application, the location of which depends on the type of macro project.
Understanding macro projects
The Scripts docker provides basic tools for working with macro projects. For access to more advanced tools, you can use the Script Editor (for VBA macro projects) or the VSTA Editor (for VSTA macro projects).
In the Script Editor, a VBA macro project is broken into four types of components, which are displayed as the following folders in the Project Explorer (see Using the Project Explorer):
In the Script Editor, you cannot move a component from one folder to another within the same project. However, you can drag a component to another project to make a copy of it there.
Related procedures
For details on creating macro projects, see the following procedures:
In the Scripts docker, do one of the following:
Project names must follow normal variable-naming conventions: They must begin with an alphabetic character, and they must not contain spaces nor special characters other than underscores ( _ ).
Some macro projects are locked and cannot be modified.
For more information, see Providing dialog boxes for macros.
Do one of the following:
Detailed documentation on creating class modules is beyond the scope of this documentation.