MACRO runs a script (or "macro") in scripting enabled software like AutoCAD, Rhinoceros, MatLab, Word, Excel, etc.

Syntax

MACRO(ProgramName$, (Script)FileName$, Macro$, OutputFile$/LocationLabel$, [ContinueCaption$])

Arguments

ProgramName$ is ProgramName$ is a string expression containing the name of the software to be used. Present programs tested:

(Script)FileName$ is a string expression containing the name of (drawing) file or the file in which the macro script has to be saved.
Macro$ is a string expression containing the macro script, either VBA or any other supported script.
OutputFile$ is a String expression containing the name of an output file created by the script, if any. This output file can e.g. contain a set of values computed by the script in the software used.
ContinueCaption$ is an optional string argument containing the caption of the modal continue button that is shown after posting the script to the connected software. In the case of a CAD system or drawing program, this allows you to make changes to the result generated by the script before allowing the system to continue the session.

...

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.
If OutputFile$="NullString", the MACRO() function will return a string containing "ProgramName$ script completed".
In Visio, Word and Excel the posted macro is immediately removed from the document after it has been executed.
In addition to the programs mentioned Qnowledge is alway willing to investigate implementation of the same functionality for programs not yet mentioned above

...

Page tree