Excel VB.Net constants reference

• Posted by miketeye on March 16, 2009
• 0 comments

I just felt like contributing to the visibility of these constants on the web. If you try to port VBA code from VB 6.0 to the .Net environment using VS 2003/5/8 interop assemblies for Excel, you will quickly find out that the Excel constants (typically with prefix Xl and format Xlxxxxx) no longer have global visibility. Each set of constants have been grouped into a type.

It is a pain sometimes trying to figure out the appropriate type for the constant. Luckily an MSDN page lists all the types. The page is at:

http://msdn.microsoft.com/en-us/library/aa221100(office.11).aspx# 

Hope this helps.

Cheers! 

E-mail | Kick it! | DZone it! | del.icio.us | Permalink | Post RSS