Agilent Technologies E3646A, User Manual, Page: 144 / 211

Chapter 6 Application Programs
Example Program for Excel 97
144
To write an Excel macro you must first open a module in Excel. Go to the View menu,
choose Toolbars , and then select Control Toolbox . The Control Toolbox dialog box
appears. Select the Command button in the dialog box. Click cell A1 and drag across
the cell B3. The “ CommandButton1 ” box is created. To change the button name, click
the right mouse button on that button and then select Properties. The Properties dialog
box appears. In the Properties dialog, change the “(name)” and “caption” to “Diode”.
To try the example for characterizing a diode, type “Voltages” in cell A4 and “Current”
in cell B4. In cell A5 type 0.6. Fill in the cells A5 to A15 in 0.02 increments so that
cell A15 contains 0.8.
To enter the “Diode” macro example in this section, go to the
View menu, choose
Toolbars , and then Visual Basic Editor icon. The “ Code window ” appears. Then type
the text as shown on page 139 into the “ [Moudle1 (code)] ” window. To enter the
declaration for Windows
®
95/NT, go to the Insert menu, choose Module . The
“ Module window ” appears. Then type the text as shown starting on page 141. This
module will configure all of the overhead required to communicate with the power
supply over the interface. Choose the preferred interface by setting “bGPIB=” to
“True” or “False” and change the GPIB address or RS-232 port in the routine
“OpenPort( )’’ contained in the module.
To run the macro, return back to the
Excel window and select the Run Macro button
in the dialog box and choose the macro name, and then click on the Run button . The
power supply will reset to power on condition and then step through the voltages in
the worksheet. After each step the current is measured, and recorded in the worksheet.
Make any changes necessary to suit your application in the “Diode’’ module. You
must enter the information in the modules exactly as shown or error will be generated.
If several system errors occur while attempting to run a macro, you may have to reboot
your PC to get the GPIB port or RS-232 port to work properly.
N o t e To use the example with Window
®
3.1, you will need to modify the declarations at
the top of the module. Change ‘visa32.dll’ to ‘visa.dll’ in all declarations.