beautypg.com

Communicating with excel from a vbscript – Teledyne LeCroy WaveRunner XI SERIES Operator’s Manual User Manual

Page 207

background image

O

PERATOR

S

M

ANUAL

WRXi-OM-E Rev C

207

[in, defaultvalue(0)] int startIndex,

ARIANT *pArray);

led,

TA)] int numSamples,

; HorizontalUnits([in] BSTR newVal);

newVal);

; HorizontalResolution([in] double newVal);

t *pVal); HorizontalVariances([in] int newVal);

eArray([out, retval] VARIANT * pArray);

uble *pVal); HorizontalFrameStart([in] double newVal);

op([out, retval] double *pVal); HorizontalFrameStop([in] double newVal);

rticalFrameStart([in] double newVal);

p([out, retval] double *pVal); VerticalFrameStop([in] double newVal);

ouble *pVal); VerticalResolution([in] double newVal);

al] double *pVal); VerticalPerStep([in] double newVal);

newVal);

Ver

Com

te with other programs opens up immense possibilities, both for

calc

Communicating with Excel from a VBScript

t.

OutResult.Samples = InResult.Samples

startData = 0

endData = OutResult.Samples

ReDim newData(OutResult.Samples)

USD = InResult.DataArray(False)

LastPoint = endData - 1

[in, defaultvalue(1)] int sparsingFactor,

[out, retval] V

DataArray([in, defaultvalue(TRUE)] BOOL arrayValuesSca

[in, defaultvalue(LEC_ALL_DA

[in, defaultvalue(0)] int startIndex,

[in, defaultvalue(1)] int sparsingFactor,

[in] VARIANT array);

HorizontalUnits([out, retval] BSTR *pVal)

Samples([out, retval] int *pVal); Samples([in] int

HorizontalResolution([out, retval] double *pVal)

HorizontalPerStep([out, retval] double *pVal); HorizontalPerStep([in] double newVal);

HorizontalOffset([out, retval] double *pVal); HorizontalOffset([in] double newVal);

Sweeps([out, retval] int *pVal); Sweeps([in] int newVal);

HorizontalVariances([out, retval] in

HorizontalVarianc

HorizontalVarianceArray([in] VARIANT array);

HorizontalFrameStart([out, retval] do

HorizontalFrameSt

VerticalFrameStart([out, retval] double *pVal); Ve

VerticalFrameSto

VerticalResolution([out, retval] d

VerticalPerStep([out, retv

VerticalOffset([out, retval] double *pVal); VerticalOffset([in] double newVal);

VerticalMinPossible([out, retval] double *pVal); VerticalMinPossible([in] double

ticalMaxPossible([out, retval] double *pVal); VerticalMaxPossible([in] double newVal);

VerticalUnits([out, retval] BSTR *pVal); VerticalUnits([in] BSTR newVal);

municating with Other Programs from a VBScript

The ability of The instrument to communica

ulation and for graphics, making the assembly of reports relatively simple.

Although there are direct instrument calls to Excel and other programs, you may wish to do this from a VBScrip
Here is an example: