Monday, March 19, 2012

Tutorials Using VBA and Excel for Instrument Control

This post provides two video examples on using Visual Basic for Applications (VBA) and Excel for instrument control. The first video is meant to get you started. The second video shows a quick example on reading measurement data into Excel from an instrument. Excel provides an easy way to post process and analyze measurement data with its built-in math functions and plotting capability. It is also low cost since just about everyone has Excel on their work computers. To get the instrument's address the video uses a free software program called Agilent Connection Expert. The link for downloading Connection Expert can be found at the end of this post.

For more details on using VBA just go to YouTube and search on "VBA" there is a ton of videos out there showing various features. If you know of any good VBA examples or tutorials out there please share in the "Comments" section below.

Click here to get Agilent IO Libraries (Connection Expert is part of IO Libraries)


  1. These tutorials are very helpful and handy for us students. We are currently doing our dissertation services at BestEssayEducation in instrument control and we are very pleased to find your post.

  2. I had only the basics of instrumentation and control but the tutorials have helped me to internalize and to visualize the theoretical knowledge I read in class. This is an important website and I will be directing students to this site who are interested in instrumentation and control subject as they visit our website occasionally to seek Correct my Education Dissertation.

  3. If you are a writer, blogger, especially novice one, do not miss that is a great and helpful blog for all the listed above.

  4. Thank you for posting such a great article! I found your website perfect for my needs. It contains wonderful and helpful posts. Keep up the good work!. Thank you for this wonderful Article! five nights at freddy's