Hi,
After studying the COM Excel example I was able to reassembling a tiny part of the VBA cell addressing.
[code=thinbasic]'Excel code
'for i = 1 to 20
' for n = 1 to 5
' ActiveSheet.Cells(i, n) = "Hello"
' next n
'next i
'thinBasic equivalent code
for i = 1 to 20 'Rows
for n = 1 to 5 'Column
vParam(3) = i
vParam(2) = n
vParam(1) = "Hello"
COM_Execute(pXlSheet, "Cells", %TB_DISPATCH_PROPERTYPUT, %NUMBER_OF_PARAMETERS, vParam, 0)
next
next[/code]
It is a bit long-winded but with some do-it-yourself repackaging into a function it could be something like:
[code=thinbasic]
for i = 1 to 20 'Rows
for n = 1 to 5 'Column
Cells(pXlSheet, i, n, "hello")
next
next[/code]