Hello Stefan,
For what I know, I'm afraid that is not possible.
- Visual Basic works like this:
Range("A1").Select
'Select the cell A1ActiveCell.FormulaR1C1 = "value1"
'Fill the cell A1 with "value1"Range("A2").Select
'Select the cell A2 ActiveCell.FormulaR1C1 = "value2"
'Fill the cell A2 with "value2".
.
and so on...
- Wincom works in the same way :
CALL ui.interface.frontcall("WinCOM", "CallMethod", [xlapp, 'Range("A1").Select'], [xlwb])
#Select the cell A1CALL ui.interface.frontcall("WinCOM", "SetProperty", [xlapp, 'Range("A1").Value', "val1"],[result])
#Fill the cell A1 with "val1"
CALL ui.interface.frontcall("WinCOM", "CallMethod", [xlapp, 'Range("A2").Select'], [xlwb])
#Select the cell A2CALL ui.interface.frontcall("WinCOM", "SetProperty", [xlapp, 'Range("A2").Value', "val2"],[result])
#Fill the cell A2 with "val2"
.
.
and so on...
Since the COM API is a Microsoft API, you could maybe have more precision from the Microsoft Support.
Nevertheless, as mentionned in the GDC documentation, Genero WinCOM API is slightly more strict than the COM language syntaxe :
- := notation is only allowed in version 2.00.1e (or later) ; for instance: myFunction(SourceType:=3)
- "no parenthesis" notation is not allowed ; for instance: myFunction 3 must be written myFunction(3)
- numeric constants are only allowed in version 2.00.1e (or later).
The constant list depends on the application used via WinCOM ; therefore, the list is configurable: a file named etc/WinCOM.cst gathers all the constants provided today by Microsoft for Office XP. It can be modified to add user defined constants.
Does that answer your question?
Best regards,
Lionel