Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. To create a script for the function, usually you can record a series of actions with something like a macro recorder or discribed syntax of the program you want te script to be used in. After creating the script you copy it as TEXTITEM$() into the data slot of a parameter and you use the TEMPLATE$() function to fill the script with your parameters to integrate and use it dynamically into your knowledge base.
  2. If OutputFile$="NullString", the MACRO() function will return a string containing "ProgramName$ script completed".
  3. In Visio, Word and Excel the posted macro is immediately removed from the document after it has been executed.
  4. In addition to the programs mentioned Qnowledge is alway willing to investigate implementation of the same functionality for programs not yet mentioned above

...

BEFORE executing the macro, the modal continue button will appear with the message "Select location for inluding item..." which gives the user the opportunity to manually select a location in the document on which to perform the macro (typically the inclusion of a picture or dedicated piece of text. If ContinueCaption$ is omitted in the MACRO() function or has the value "NullString", the macro will be performed on the document on the location at which LocationLabel$ occurrs, after which the session continues without further notice.

...

either creates a spreadsheet with name ExcelSheet$ and posts the macro ExcelMacro$ to Excel or simply posts the macro ExcelMacro$ to Excel if a sheet with name ExcelSheet$ is already open. ExcelMacro$ is a VBA macro that is typically created with the TEMPLATE$() function (you can create a macro. 
AFTER executing the macro, the modal continue button will appear with the message "Press OK to Continue" which gives the user to check the result of whatever macro has been run. If ContinueCaption$ is omitted in the MACRO() function or has the value "NullString", the macro will be performed on the sheet, after which the session continues without further notice.

...