RIGOL Technologies

Welcome, Guest Login

Support Center

Simple Excel VBA Control program DSA8, DSA1000, DSA1000A Spectrum Analyzers

Last Updated: Dec 31, 2015 03:22PM PST

Simple Control Excel Program

The Rigol SimpleControl_VISA_DSA is designed to allow user's that own Microsoft Excel(c) 2010 or greater the ability to control a Rigol Digital Spectrum Analyzer using the built in VBA (Visual Basic for Applications) tools.

NOTE: The program is compatible with the DSA 800, 1000, and 1000A    spectrum analyzers.

Download the program and instructions as a zip file here.

The basic code allows you to:
•    Search the available USB, GPIB, and RS-232 buses for instruments. 
•    Select a Rigol DSA
•    Perform an identification query (IDN?)
•    Return active Trace 1 data
•    Return stored trace data. You can retrieve any files stored as BIN to the internal storage of the instrument. These files terminate with “.trc”. 
NOTE: The program utilizes NI-VISA for communications and requires that    NI-VISA is installed on the computer used for control.
1.    Install all necessary software, including NI-VISA and Microsoft Excel.
2.    Download and install the SimpleContol spreadsheet (*.xlsm) 
3.    Connect the instrument power cord and communication cable.
4.    Open the SimpleControl Spreadsheet. 
NOTE: The SimpleControl Program utilizes Macros. You will need to enable Macro's for Excel in order to successfully use the program. See the following figure for the location of Macro controls. Be cautious, as enabling Macros can allow easier entry for viruses to your system. 

5. Click on the button labeled Available Instruments. This command will search through the USB, GPIB, and Serial buses for instruments that are connected.
6.    Using the drop-down box, select the address for the instrument you are interested in controlling. 
NOTE: DSA addresses can be found using the “DSA” string element in the    Serial Number element in their VISA address. 
   See below for an example.
DSA1030A connected via USB: “USB0::0x0400::0x09C4::DSA1A124400151::INSTR”

7.    Select the IDN? Button to request an identification string from the instrument. A typical IDN? Return is shown below.

8.    To take instant readings of traces, manually configure the DSA to the proper settings for capturing the signal of interest. Once the trace is displayed,  it can be retrieved using the Read Trace button. Here is a sample waveform:
•    C8 returns the identification string
•    C9 returns scan start frequency
•    C10 returns scan stop frequency
•    Column E returns frequency steps
•    Column G returns measured amplitude
9.     To retrieve a waveform stored internally, Enter the correct filename in Cell C14 and press the Load Trace button. 
•    For example, if we had previously stored a file named “1.trc” to the DSA, you would simple enter the number “1” into Cell C14 and press Load Trace as below:
10.     Now that the data is in Excel, you can perform many different types of data manipulation and analysis.
Login above for personalized content


seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
Invalid characters found