Excel Automation Example-5700A

This was just something I threw together based on an example from National Instuments. The only parts of this that have have automation are the AC Voltage and Wideband Frequency Response tabs. Please forgive the spaghetti code...if I was to do this over again, I'd do it way different, but it'll give you an example of how to read and write from the GPIB into an excel spreadsheet. It's pretty raw...there's no error checking or anything like that. If you want to stop the macro once it starts hit the escape key.

You'll need to have your USB-GPIB adapter up and running first...if you're running NextGen it should work fine. (At least it has on the ones I've tried). Connect your 5700A to the 5790A as per the appropriate K-pro step and hit the start button.

Big Disclaimer....this is for example purposes only. Please consult your local quality manager and 00-20-14 for guidance on using spreadsheets and software.