New features in TRANSACTION version 10.6/10.7 > Running scripts > Publishing macros in an Excel workbook

Back to

Running scripts

Publishing macros in an Excel workbook

In TRANSACTION, you can publish macros in Excel workbooks and customize aspects of the variables. You can also edit macros in that are already published to workbooks from within TRANSACTION without opening VBA. Macros created in TRANSACTION can be run in the TRANSACTION and RUNNER clients and in the RUNNER add-in for Excel.

To publish a macro

  1. Create the macro in or copy it to a .txt file.
  2. In the Run pane, click Publish Macro.
  3. In the Winshuttle Macro Publisher dialog box, click Import.

    Browse to the location of the .txt file.

  4. Click Save to publish the macro.

To edit macros already published to workbooks

  1. In the Run pane, click Publish Macro.
  2. From the list in the Winshuttle Macro Publisher dialog box, select the macro you want to use. Click Edit.
  3. The text editor opens to accept your changes. Click Save.

To enable a macro as a button in a workbook

Note: Excel files that contain a space in their filename cannot contain buttons.

  1. In the Run pane, click Publish Macro.
  2. From the list, select the macro you want to use.
  3. Click Make Button.
  4. In the Caption box, name the button and in the Cell Address box and specify where you want the button to appear. Click OK.

To run a macro

  1. In the Run pane, click Publish Macro.
  2. From the list, select the macro you want to use. Click Run.

Macro templates

Macro templates are available for you to customize to your needs. To download templates, go to wise.winshuttle.com.

The form can be generated from only one method specified in the <MN></MN> tag. Variables must be coded in the following format:

<WSM_Declaration><VN>Variable Name</VN><LT>Label Text</LT><DV>Default Value</DV><DT>Data Type</DT><MN>Method Name</MN></WSM_Declaration>

To add your own variables

  1. Click Publish Macro.
  2. Click Import to import the macro or template.
  3. Click Edit.
  4. Add the variables. Click Save.








Also in this section
Running multiple or linked files
Scheduling runs
Run options, troubleshooting errors, and Launch GUI
Advanced run settings
Writing Headers
Uploading long text
Uploading characters in Japanese to SAP
Windows scripting