John,

There's a program on my website that will create a .h file of the constants contained in the OLB file. I've not used it on the O2K files but it should work. I think Rick Strahl also has something on his site, www.west-wind.com

>Does anybody know where I can get a definition of all the constants that show up when I use the macro recorder to do something in Excel 2000? I can't even find a header file on my system to use. Plus I'm getting a little sick of guessing which number the constant is actually representing :-)