6 Application Programs
266 Keysight 34420A User’s Guide
Microsoft Excel Macro Example
You can use Windows™ Dynamic Data Exchange (DDE) to send commands to the
meter and return measurement results directly into a Microsoft® Excel
spreadsheet.
This example uses the Keysight “Instrument Tools for Windows” and the 82335B
GPIB Interface. The “Instrument Tools for Windows” contains two programs to
support GPIB operations, an Interactive GPIB program and a GPIB DDE Server.
To use the “Instrument Tools for Windows” with Microsoft® Excel, follow this
general procedure:
1 Install Tools for Windows (if not already installed).
2 Start the Interactive GPIB application and create and save a configuration file
(.IBC file) that describes the interface with the meter. Be sure EOI is disabled
and EOL is set to include the <lf> character. Refer to the “Instrument Tools for
Windows” User’s Manual for procedures and descriptions of creating a
configuration (.IBC) file.
3 Start the GPIB DDE server. This application starts and minimizes to an icon.
4 Run the macro shown in the example.
In the macro, the following commands are part of the GPIB DDE program and
are documented in the “Instrument Tools for Windows” User’s Manual. All
other commands are Microsoft® Excel commands and are documented in the
Excel function reference.
–[Abort]
– [clear(device)]
– EnterS
–EOL
– OutputS
You can test your interface connection in the Interactive GPIB program by
sending an output string of *IDN? and entering the results. A typical response is
shown in the example in cell F4.
To Next Page
Loading...
