Home / Knowledge Base / Knowledge Base Spectrum Analysers / Knowledge Base DSA800 Series / Using Excel and VBA with DSA800 spectrum Analysers

Using Excel and VBA with DSA800 spectrum Analysers

Facebook

Posted on: December 16th, 2020 by Doug Lovell

Microsoft Excel and Visual Basic for Applications (VBA) is a great way for engineers who need to analyse and archive data from their instrument to access the data without deep programming skills.

With this in mind, we have created VBA examples for some of our instruments including this one for Spectrum Analyzers including the DSA800 family.

Download the example file here

Users should also install UltraSigma to make certain all the necessary drivers exist on their system.

Download the UltraSigma install pack here

Once UltraSigma is installed, the VBA macros can be used to communicate with the instrument. We have added a few buttons to make capturing a spectrum from the instrument simple.

Here is a look at the spreadsheet:

Download further instructions for getting started using this Excel file here

AC Power Supplies

DC Power Supplies

Electronic Loads

Test & Measurement

EMC Pre-Compliance

Safety Testers

Soldering Irons / Test Tools

Calibration & Metrology Instruments