Help needed in SAP UDF _SAPObjValueSet

[sagarphirke]

Hi;

I need a help in executing 1 SAP transaction.

I am reading a XLS file & passing that value to SAP Transaction.

Here I am using the  _SAPObjValueSet with variable ; but it seems to fail.

For $i = 1 To $rows ;Loop
    Local $sCellValue = _ExcelReadCell($oexcel, $i, 1)


    _SAPObjValueSet("usr/txtTERMSCHL-LOW","$sCellValue")
    _SAPObjValueSet("usr/ctxtABRDATV", "01.01.2001")
    _SAPObjValueSet("usr/ctxtABRDATB", "31.12.2020")
    _SAPVKeysSend("F8")

Next

Can any one help me please ?

[FireFox]

Hi,

I'm not familiar with this UDF, but I know that autoit doesn't support string interpolation.

Just pass the variable directly instead of enclosing it with quotes.

_SAPObjValueSet("usr/txtTERMSCHL-LOW", $sCellValue)

 

Br, FireFox.