Introducing Winshuttle TRANSACTION > TRANSACTION Tutorial > Introduction: Publishing a data sheet with an embedded script
Introduction: Publishing a data sheet with an embedded script
Most often, scripts are created to be distributed with a data sheet that is a template that users will copy, fill in, and then run in a run-time only Winshuttle product called RUNNER.
Bind script
You can bind a script to a data sheet to ensure that the script is run only with that data template.
- A script can run on the sheet it is bound to, but also on the active sheet.
- A parent script runs either on the specified bound sheet or on the active sheet.
- If the option carry sheet is on, the child script runs on the sheet on which parent file ran (Active sheet).
- If the option Carry Sheet is off, the child script runs on the sheet specified in the script itself.
- For backward compatibility, earlier published files run either on active sheet or on the sheet that the parent script is bound to.
To embed a script in a data sheet
- On the Run pane, on the selection bar, click Publish script.
The Publish dialog box appears.
- You can click the folder icon on the right to browse to the TRANSACTION script folder you want to use. You can also type the file path to the Excel template.
- Enter the Sheet Name to which the TRANSACTION script will be published.
- Select whether you want to bind the TRANSACTION script to the sheet it is being published to. If you check this option, you can run your embedded script only with the sheet it is bound to.
- Enter a short description of the TRANSACTION script that describes the purpose or use of the file.
The current TRANSACTION script is exported to the Excel template you select.