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).]