Bryce:I saw the same thing and had the same tingly feeling. Then I tried it and no worky.
I think the extra vartype() "types" are only used to check the return values from OLE methods and properties. But since (probably) they always come back as strings anyway - how would vartype() work ?
Might be worth a quick test against Excel to try and return a floating-point value and see how KiX interprets !
Shawn.
Yup - that's what it is used for...
code:
break on cls
$excel = createobject ( "excel.application" )
if $excel
$excel.visible = 1
$excel.displayalerts = 0
$workbooks = $excel.workbooks
if $workbooks
$= $workbooks.add()
$cell = $excel.activecell
if $cell
$formula = ".123 + .234"
$cell.formula = "=$formula"
$result = $cell.value
?"vartype=" vartype($result)
endif
endif
endif
?"pause..." gets $k
$excel.quit()
exit
Does anyone see any mention of how to release an object in KiXtart 2K1 ? I assume it's something like releaseobject() but I see no mention of it in the manual or in the examples...
Shawn..
I keep forgetting that the COM stuff isn't done yet !
But here's the deal. I hope that Ruud will be changetyping OLE Variants into something that usefull in KiXtart. Unless he plans on implementing some new builtin variable types. example...
Floats,Numbers,Bools changetyped to integers ?
BSTRS/DATES changetyped to strings ?
SafeArrays transformed into arrays ?
As it is, I can't see anyway of using these "other" types ?
[I know, I know, it's not done yet !]
Shawn.
[This message has been edited by Shawn (edited 02 April 2001).]
