Finding Constant Values

Here's a problem: You're automating Outlook in your Excel code (or any Office program for that matter), and need to find the value for an Outlook constant because you know you can't use built-in Outlook constants in late-bound Excel VBA code. How do you usually do it? Do an Internet search for the number?

One shortcut I discovered recently runs as follows:

1. Add the library reference in the VBA IDE (if necessary);
2. Open the Object Browser (press F2);
3. Find and select the name of the object library in the upper combo box;
4. Type the name of the constant in the lower combo box;
5. Look at the bottom of the Object Browser dialog box for the constant value.

Brilliant! I'm still amazed every day at what I learn about Excel.

Of course, you could always use the list of enumerated constants and not worry about using magic numbers in your code!