RIGOL Technologies

Welcome, Guest Login

Support Center

Simple Excel 2010 VBA Control program for all Oscilloscopes

Last Updated: Jan 14, 2016 09:13AM PST
Simple Control Excel Program

The Rigol SimpleControl_VISA programs are designed to allow user's that own Microsoft Excel(c) 2010 or greater the ability to control a Rigol Oscilloscope using the built in VBA (Visual Basic for Applications) tools.

Download this article and the XLSM files for Excel together in a zip file here.

NOTE: There are different programs available. Each is tailored for use with different Scope Series:
Click the link to download the files you need:

▪ “ SimpleControl_VISA_DS1Z”
              • DS1000Z Series

▪ “ SimpleControl_VISA_DS1”
              • DS1000E and DS1000D Series

▪ “ SimpleControl_VISA_DS6” 
              •    DS6000 Series
              •    DS4000 Series
              
•    DS2000A Series

▪ “ SimpleControl_VISA_DS1CAB” 
              •    DS1000CA Series
              •    DS1000B Series


The basic code allows you to:
•    Search the available USB, GPIB, and RS-232 buses for instruments. 
•    Select a Rigol Oscilloscope
•    Perform an identification query (IDN?)
•    Return Channel 1 data
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: DS6000 series scopes can be identified with the string DS6 in their    VISA address. DS4000 series scopes can be identified with the     string DS4 in their VISA address. See below for an example.
                  DS6000 connected via USB: “USB0::0x1AB1::0x04B0::DS6xxxxxxxx::INSTR”
                  DS4000 connected via USB: “USB0::0x1AB1::0x04B0::DS4xxxxxxxx::INSTR” 
       8. Select the IDN? Button to request an identification string from the instrument. A typical IDN? Return is shown below.
 
9.     Manually configure the scope to the proper settings for capturing the waveform of interest. Once the waveform has been captured, it can be retrieved using the Read Scope button. Here is a sample waveform:
 
•    Cell C3 returns the horizontal timebase
•    C4 returns timebase offset
•    C5 returns channel vertical scale
•    C6 returns channel vertical offset
•    Column E returns raw unsigned byte array data from the scope
•    Column G returns calculated time
•    Column I returns calculated voltage
10. Now that the data is in Excel, you can perform many different types of data manipulation and analysis.
Login above for personalized content

RIGOL USA Web Site

f14c465fd642ac49fa5a4bd437615e15@rigol.desk-mail.com
https://cdn.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete