VBEval - SetCell

[snapper1969]

Hi,

With the code snippet below, what would the VBEval>SetCell params be if I wanted to use theValue?.

I've tried various ways but can't seem to get it to work?.


VBRun>OpenExcelFile,%SCRIPT_DIR%Input.xls
VBEval>GetCell("Sheet3",10,9),Field_1
VBEval>SetCell("Sheet5",20,5,Field_1),nul


Thx,

John

[Marcus Tettmar]

VBEval>GetCell("Sheet3",10,9),Field_1
VBEval>SetCell("Sheet5",20,5,"%Field_1%"),nul

[durexlw]

With the code snippet below, what would the VBEval>SetCell params be if I wanted to use theValue?.

VBRun>OpenExcelFile,%SCRIPT_DIR%Input.xls
VBEval>GetCell("Sheet3",10,9),Field_1
VBEval>SetCell("Sheet5",20,5,Field_1),nul

For one:
It should be with "%" around the variable "Field_1". For Macro Scheduler "Field_1" without the "%" is just a string, but if you pass to VBScript "Field_1" without the "%", it becomes an invalid string cause VBScript needs the quotes "" around a string.

Like this:

Code: Select all

VBEval>SetCell("Sheet5",20,5,%Field_1%),nul

When it comes to VBScript, values and strings, keep in mind:

Code: Select all

Let>sString=Sometext
VBEval>TestFunction("sString"),r --> passes the string: "sString"
VBEval>TestFunction(%sString%),r --> passes an invalid string: SomeText... invalid to VB, cause it has no quotes "" around it 
VBEval>TestFunction("%sString%"),r --> passes the string: "Sometext"

So if what "Field_1" contains is a string, you may have to put quotes around it to make it valid for VBScript
Like this:

Code: Select all

VBEval>SetCell("Sheet5",20,5,"%Field_1%"),nul

There may be mistakes in the VB parts... make sure with the debugger that "Field_1" actually contains what you like it to contain and keep an eye on it if it contains a string or not, like mtettmar says.

[Marcus Tettmar]

For one:
It should be with "%" around the variable Field_1

And should also include quotes if it is a string. VBScript expects quotes around strings. See my post above.

[snapper1969]

Thankk you Marcus....works perfectly


John