Skip to content

VBA

How do I deploy macros?

You can save macros in the session document project file or in the common project. Macros that are apply to a particular session are typically saved to session document project, which is included as part of the session document file.

Macros that are intended for use by more than one project are saved in the common project, which is saved in the vbaProject.bin file. You ‘ll need to deploy this file to one of the following folders:

For all users:

[CommonAppDataFolder]\Micro Focus\Reflection\Desktop\v17.0\

For only the user who installs:

[AppDataFolder]\Micro Focus\Reflection\Desktop\v17.0

For more, see Package Sessions and Custom Settings Files.

How do I run or convert legacy macros?

To run legacy macros in Reflection or convert them to Reflection macros, see Using Macros Created with other Products.

How do I set up a macro to screen scrape data?

To set up screen scraping, see "Screen Scrape Data to a Spreadsheet" in the Reflection VBA Guide.

Can I call a session from JavaScript?

Reflection Desktop does not support opening a session from JavaScript.

How do I install Reflection and VBA with MSI directly?

To deploy Reflection directly with MSI and get information about where to find the files required to install the .Net and VBA versions required for Reflection, see Deploy with MSI. You can use the same commands to deploy the VBA .msi as you use for the Reflection .msi.

How do I start and stop macro recording?

Record macros on the Tools tab as shown in Record, Run, and Edit VBA Macros in the Help.

Can I handle legacy macros with ActiveX solutions?

Reflection Desktop does not support ActiveX controls. If you have these controls in your legacy macros, you will need to replace the code.

NOTE:The Reflection .Net API supports embeddable .NET controls. These controls are not available for VBA.

How do I get started with VBA and what are some typical ways to use it?

See the Reflection VBA Guide.