Using Excel and VBA with DSA800 spectrum Analysers

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