5 Application Programs
174 E364xA User’s and Service Guide
To write an Excel macro:
1 You must first open a module in Excel.
2 Go to the View menu, choose Toolbars, and then select Control Toolbox. The
Control Toolbox dialog box appears.
3 Select the Command button in the dialog box.
4 Select cell A1 and drag across cell B3. The CommandButton1 box is created.
5 To change the button name, click the right mouse button on that button and
then select Properties. The Properties dialog box appears.
6 In the Properties dialog, change the (name) and caption to Diode.
7 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 cells A5 to A15 in 0.02
increments so that cell A15 contains 0.8.
To enter the Diode macro example in this section:
1 Go to the View menu, choose Toolbars, and then select the Visual Basic
Editor icon. The Code window appears.
2 Then, type the text as shown on page 169 into the [Module1 (code)] window.
To enter the declaration for Windows 95/NT, go to the Insert menu and choose
Module. The Module window appears.
3 Then, type the text as shown starting on page 171. 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 to the Excel window, select the Run Macro button in the
dialog box, choose the macro name, and then click Run. The power supply will
reset to the 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 an 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 or RS-232 interface to work properly.
To Next Page
Loading...
Need help?
General
