Agilent Technologies E3634A, E3633A manual T e, 140

Chapter 6 Application Programs

Example Program for Excel 97

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.

140