• Visionic Spectrum Analyzer: IP connections and routing
    Visionic Spectrum Analyzer is a client-server program. In many cases, the client can be physically far away from the server; and in such cases there are security measures such as firewalls,...
  • VSA IP connections and routing
    Visionic Spectrum Analyzer is a client-server program. In many cases, the client can be physically far away from the server; and in such cases there are security measures such as firewalls,...

How to export Visionic macro to VBScript

It is often required to export recorded Visionic macros to the VBScript. This option can be useful in variety of situations. For example: 

  • Allow your macros to be started from another process as command-line processes
  • Allows you to customize operations in the macros using VBScript language
  • Allows your macros to be started from a scheduled job (cron job) to periodically perform operations.

 The export function is not a part of Visionic5, mostly because of the changing nature of the macro language as we know it. In the last days of Visionic4, the language has been rapidly expanded to include new instructions, such as looping through record set and similar. These new features blocked the existing “Export to VBScript” functionality.

You can download VBScript files that will export Visionic 5 macros the project into the VBScript language. The process is very simple and can be done in the following way:

Unzip all files into the single directory and then from the command prompt execute this command:

cscript.exe export_macro.vbs //nologo “<full path to compiled MDB file>” “<macro name>” >macro.vbs

In the command line above, replace the following:

Replace what

Example

<full path to compiled MDB file>

C:\Users\John\Documents\Visionic Projects\Demo\ini_files\database\demo1.mdb

<macro name>

Name of existing / already recorded macro. If macro name has space(s) in the name, surround it with quotes.

 Once the script is exported, open the generated VBS file in a file editor. As you can see the macro is “embedded” in the sub called “RunMacro”. At the top of the code there is initialization routine for the parameters; you can change this instruction to provide macro parameters from command line or similar.

The macro can be run with the command:

cscript macro.vbs

 The constants on the top of the resulting VBS file dictate the IP address of the server (whether the server is on local machine or not).

Once exported, the macro can be manually updated as necessary. Feel free to change macro’s code and experiment with the VisApp object (source of which is at the end of the file).