Enumeration of COM object properties (Excel)

I find myself looking to the VB documentation to determine the enumeration of various COM object properties. In VB, the string xlHAlignLeft can be used, however only the numeric (-4131) can be used in MATLAB. Are the numeric values of these character array pairs defined anywhere on the COM application, such that they could be referenced to allow the string rather than the number to be used? Just curious.

[dpb]

"Are the numeric values of these character array pairs defined anywhere on the COM application,"

No. The constants are only named in the VBA environment through the intellisense link or in the doc.

There isn't any link between the MATLAB code editor and VBA by which that connection is made although I suppose if one were ambitious-enough, one could write an extension (or is the TMW editor even user-extensible?).

It is a real inconvenience in using COM in MATLAB, agreed.

[Matt C]

Thank you for the definitive response. I will probably just write a library to streamline the process. There are actually a few different lists online of all the enumerations. One could try and read these with urlread() and build a class...but that sounds like a lot of work.

[dpb]

That or similar has always been my approach -- or just pick the ones of the C# header files of interest--I rarely use but a handful at any time from the gazillions there are.