Merry Christmas and a Happy New Year!

Our office will be closed from 24th December to 2nd January 2024. Orders placed after 4 PM on 23rd December will be processed when we reopen on 3rd January 2025.

CONTACT ACCOUNT

TEL: 0118 978 6911

Basket

FREE SHIPPING £75+

CELEBRATING 50+ YEARS

PRICE MATCH GUARANTEE

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

Post

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