Info

Figure 2.8

In the Immediate pane of the VB Editor, query to see the true value of constants such as xlFixedWidth.

Figure 2.8

In the Immediate pane of the VB Editor, query to see the true value of constants such as xlFixedWidth.

If you were an evil programmer, you could certainly memorize all these constants and write code using the numeric equivalents of the constants. However, the programming gods (as well as the next person who has to look at your code) will curse you for this.

In most cases, the help file either specifically calls out the valid values of the constants, or offers a blue hyperlink that causes the help file to expand and show you the valid values for the constants (see Figure 2.9).

Figure 2.9

Click the blue hyperlink to see all of the possible constant values.Here, the 10 possible xlColumnDataType constants are revealed in the middle of the help topic.

Figure 2.9

Click the blue hyperlink to see all of the possible constant values.Here, the 10 possible xlColumnDataType constants are revealed in the middle of the help topic.

0 0

Post a comment