print enumerations

[Guest]

Hi,

Is there a way to extract the 'English' of an enumeration in VBA? It's too
bad they don't work like an array a simple loop would do the job.

For example get all of the values of DataTypeEnum

like adBigInt and so on

Or am I stuck with using charts like the one at
http://msdn.microsoft.com/library/d...s/ado270/htm/mdcstdatatypeenum.asp?frame=true or viewing them in object browser?

Thanks
Mark

 

[Guest]

I found the answer.
http://www.jasonbock.net/JB/FindingEnumerationNames.aspx