on Apr 15, 2015The attached Excel file contains a sample program that is intended to be used with 'Keysight Technologies B2900-series Benchtop Source Meters.
Description:
This sample program sources a constant voltage and then measures Voltage, Current, Resistance, and the time-stamp. These values are returned from the instrument and parsed into the spreadsheet. If you are not familiar with using Excel VBA (Visual Basic for Applications) to automate test equipment, the attached Word document provides instructions for getting started. Even if you aren't using Excel VBA the sample program may still be of use as you can see the instrument commands that are used and the sequence that they are sent in.
Requirements:
The Keysight IO Libraries (www.keysight.com/find/iolib) must also be installed.
Within Excel VBA you must also add in the needed References.
Within VBA please go to Tools->References and make sure you have added the following references
Agilent VISA COM Resource Manager 1.0
VISA COM 5.5 Type Library
(Note: these revision numbers may change with time)
Instructions:
Use Connection Expert, which is a utility within the Keysight IO Libraries, to get
the VISA address of your instrument.
In the code below find the line that starts with "Set instrument.IO". 'Within this
line is an instrument address inside the quotes. Replace the address with that of
your instrument.
References:
Keysight B2900 Series Benchtop Source Measure Unit Programmer’s Guide
http://literature.cdn.keysight.com/litweb/pdf/B2910-90020.pdf
Keysight B2900 Series Benchtop Source Measure Unit SCPI Command Reference
http://literature.cdn.keysight.com/litweb/pdf/B2910-90030.pdf
See additional comments in the code.
Edited by: grant_suter on Apr 15, 2015 1:41 PM
Edited by: grant_suter on Apr 15, 2015 1:42 PM
Description:
This sample program sources a constant voltage and then measures Voltage, Current, Resistance, and the time-stamp. These values are returned from the instrument and parsed into the spreadsheet. If you are not familiar with using Excel VBA (Visual Basic for Applications) to automate test equipment, the attached Word document provides instructions for getting started. Even if you aren't using Excel VBA the sample program may still be of use as you can see the instrument commands that are used and the sequence that they are sent in.
Requirements:
The Keysight IO Libraries (www.keysight.com/find/iolib) must also be installed.
Within Excel VBA you must also add in the needed References.
Within VBA please go to Tools->References and make sure you have added the following references
Agilent VISA COM Resource Manager 1.0
VISA COM 5.5 Type Library
(Note: these revision numbers may change with time)
Instructions:
Use Connection Expert, which is a utility within the Keysight IO Libraries, to get
the VISA address of your instrument.
In the code below find the line that starts with "Set instrument.IO". 'Within this
line is an instrument address inside the quotes. Replace the address with that of
your instrument.
References:
Keysight B2900 Series Benchtop Source Measure Unit Programmer’s Guide
http://literature.cdn.keysight.com/litweb/pdf/B2910-90020.pdf
Keysight B2900 Series Benchtop Source Measure Unit SCPI Command Reference
http://literature.cdn.keysight.com/litweb/pdf/B2910-90030.pdf
See additional comments in the code.
Edited by: grant_suter on Apr 15, 2015 1:41 PM
Edited by: grant_suter on Apr 15, 2015 1:42 PM
Hi, I am trying to build my own Excel VBA program to measure current vs time and general transients with B29002A. Do you have any idea how I can do that? With Quick IV the time domain measurements are very easy, but if you want to write your own program is very complicated. Thank you in advance.