Datasheet

❑ Add-in Manager — This command displays the Add-in Manager, which lists the add-in projects

registered on the computer. You can use the Add-in Manager to enable or disable these add-ins.

❑ Macros — The Macros submenu contains commands that help you create, edit, and execute

macros. See the section “Macros” later in this chapter for details.

❑ Upgrade Visual Basic 6 Code — This command displays the dialog box shown in Figure 1-37. If

you enter Visual Basic 6 code and click Upgrade, the dialog box translates the code into Visual

Basic 2005 and inserts it at the current position in the code. Note that the result is not always

perfect, so you should always review it. For example, the dialog box translates the code shown

in Figure 1-37 into the following code.

‘UPGRADE_WARNING: Lower bound of array values was changed from 1 to 0. Click for

more: ‘ms-help://MS.VSCC.v80/dv_commoner/local/redirect.htm?keyword=

“0F1C9BE1-AF9D-476E-83B1-17D43BECFF20”‘

Dim values(10) As Short

Dim i As Short

For i = 1 To 10

values(i) = i

Next i

In this example, you would at least need to re-evaluate the logic to account for the new array’s

bounds starting at zero instead of one. You might also want to change the data types of the array

and variable

i from Short to Integer.

❑ External Tools — This command displays a dialog box that lets you add and remove commands

from the Tools menu. For example, you could add a command to launch WordPad, MS Paint,

WinZip, and other handy utilities from the Tools menu.

❑ Performance Tools — This submenu contains performance proﬁling tools such as the Perfor-

mance Wizard and the New Performance Session command.

Figure 1-37: This dialog helps convert Visual Basic 6

code into Visual Basic 2005 code.

Part I: Getting Started

37055c016.qxd 4/8/07 12:46 PM Page 38