Topic: vlax-invoke with vlax-get-property

[Coder]

Hello guys .

is there a way to use the vlax-invoke with vlax-get-property to pass over the the variant value of the vlax-get-property ?

I am collecting a value from excel file from a cell like this .

Code: [Select]

(vlax-get-property cells "Item" 7 3)

Thanks in advance 

[gile]

Hi,

Try (not tested):

Code - Auto/Visual Lisp: [Select]

1. (vlax-get cells "Item" 7 3)

[Coder]

Hi gile

That gives me error . 
; error: too many arguments

[Coder]

Any other suggestion please ?

[Lee Mac]

What's wrong with using vlax-get-property and working with the variant?

[Coder]

Hi Lee ,

I just want to get the value without converting it from variant to real value cause this takes time if we have many variants to convert .

Or maybe you have another way to work around this other than vlax-invoke function ?

Thank you .

[ronjonp]

Just guessing here:


(vlax-get cells 'Item '(7 3))

[Coder]

Just guessing here:


(vlax-get cells 'Item '(7 3))

Hi ronjonp

Also it gives error message . ; error: too many arguments 

[ronjonp]

After a quick test this seems to be the most direct route to get the value:

Code - Auto/Visual Lisp: [Select]

1. (vlax-get (vlax-variant-value (vlax-get-property cells 'item 1 1)) 'value2)

[Coder]

After a quick test this seems to be the most direct route to get the value:

Code - Auto/Visual Lisp: [Select]

1. (vlax-get (vlax-variant-value (vlax-get-property cells 'item 1 1)) 'value2)

Thank you ron for your help , that works like a charm 

Cheers

[ronjonp]

Glad to help