I found a way to cope with them when passing them as strings as in
Code: Select all
=CC("A1:B1", "parametri")
Code: Select all
function cc(my_range, my_parset as string) as double
Dim myScript As Object
Dim varIn(1),varIdx(0),varOut(0) As Variant
varOut = Array()
myScript = GetPythonScript("canoni/calcolo.py$CCanone", "document")
varIn(0) = my_range
varIn(1) = my_parset
cc = myScript.invoke(varIn,varIdx,varOut)
end function
Code: Select all
=CC(A1:B1, "parametri")
Code: Select all
function cc(my_range as object, my_parset as string) as double
Dim myScript As Object
Dim varIn(1),varIdx(0),varOut(0) As Variant
varOut = Array()
myScript = GetPythonScript("canoni/calcolo.py$CCanone", "document")
varIn(0) = my_range.getRangeAddressesAsString()
varIn(1) = my_parset
cc = myScript.invoke(varIn,varIdx,varOut)
end function
Code: Select all
BASIC runtime error.
Object variable not set.
Thanks for any hint