Referencing VBScript arrays from MacroScript

Example scripts and tips (replaces Old Scripts & Tips archive)

Moderators: Dorian (MJT support), JRL, Phil Pendlebury

Post Reply
User avatar
Marcus Tettmar
Site Admin
Posts: 7380
Joined: Thu Sep 19, 2002 3:00 pm
Location: Dorset, UK
Contact:

Referencing VBScript arrays from MacroScript

Post by Marcus Tettmar » Wed Aug 06, 2003 11:00 pm

Contributed By: Marcus Tettmar [email protected]
Submitted On: 07/08/03

To reference VBScript variables and arrays simply use the VBEval function:

VBEval>VBScriptVariable,MacroScriptVariable

This puts the value of the specified VBScript variable into a local
MacroScript variable.  The VBScript Variable must exist in a previously
declared VBScript block.

The following example returns the value in a two dimensional array:

VBEval>MyArray(1,2),MyField

For a real-life example see Import data from CSV file into
multidimensional array

Post Reply
Sign up to our newsletter for free automation tips, tricks & discounts