Welcome, Guest. Please login or register.
04-14-2021 -- 23:25:54

Login with username, password and session length

Top 10 Posters

flew-da-coup (1303)
Hawaii596 (1017)
griff61 (580)
Hoopty (548)
docbyers (544)
MIRCS (535)
CalLabSolutions (523)
Thraxas (498)
  • Total Posts: 19304
  • Total Topics: 3677
  • Online Today: 36
  • Online Ever: 242
  • (04-19-2014 -- 19:20:34)
Users Online
Users: 0
Guests: 26
Total: 26


Excel Automation Example-5700A.

  • Filesize: 327 Kb
  • Views: 3831
  • Downloads: 1039
  • Created: 08-02-2009 -- 03:33:08
  • Last accessed: 04-12-2021 -- 02:44:31
Rating: (2 Rates)


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.

DISCLAIMER:  This site is not an official US Air Force site, it is intended for private use only.  It is not endorsed, in any way, by the US Air Force, the DoD, or any other governmental agency.  Additionally, all information found within this site is just that, it is NOT meant to be used in place of authorized publications.

All logos and trademarks in this site are property of their respective owner.

All forum content is the property of the respective poster, all the rest 2004-2017 by PMEL Forum.