Passing Enumeration value using Jacob bridge (COM/ActiveX)

Question

Does anyone know if there's a way to pass an enumeration value using Jacob?

ComObj.ComEnum.enumVal1
ComObj.ComEnum.enumVal2

I'd like to pass enumVal1 or enumVal2 as a Variant.

o.invoke("Action",new Variant("enumVal1"));   \\just pseudo code

score 0 · Answer 1 · edited Dec 24 '13 at 15:08

0

The enum values are available in the Object Browser of the Macro Editor.

enter image description here

edited Dec 24 '13 at 15:08

Mohsen Safari

6,669
5
42
58

answered Aug 26 '13 at 10:32

Chadi

737
1
6
21

score 0 · Answer 2 · answered Mar 11 '16 at 15:32

The OP seems to be asking about how to make the actual call... of which obtaining the underlying values (as shown by @ChadiEM) is be one part.

I found a post on the subject which says the values ... correspond to internally stored numbers and An enumeration in VBA is always of data type Long.

So, with this info and values , it's simply a matter of passing a Variant with the value as a long. For example:

o.invoke("Action",new Variant(34L));

I'm sure there's a way to get actual "Enumeration" data structures, but this was good enough for me.

Passing Enumeration value using Jacob bridge (COM/ActiveX)

2 Answers2