Treffer: A versatile platform for programming and data acquisition: Excel and Visual Basic for Applications.

We have switched to a new software platform to for instrument interface and data collection in our upper-division Sensor Laboratory course. This was done after investigating several options and after several meetings with our industrial advisory board. This change was motivated by a campus-mandated change in operating system, plus expiring software licenses. We decided on the Visual Basic for Applications platform (VBA), which resides in the Microsoft Office suite (in particular, MS Excel). This meets the recommendations of our advisory board, which strongly urged that we use a "traditional" programming language, as opposed to a graphical one, in order to provide our students the broadest possible applied programming "base." Further, it has the advantage that the platform is widely available and the required add-ins are free, so that graduates (and other programs) are able to use this as well. Finally, this approach has the added benefit of extending the students' prerequisite computer programming into VBA, which is useful beyond the realm of instrument control and data acquisition. This paper will describe the resources that were collected--and modified--by the author, for the apparently novel combination of VBA, 64-bit programming, and access to both serial/USB and GPIB instrumentation, and provides examples of implementation. The basic principles of VBA for non-experts will also be given, as well as strengths and drawbacks of this approach. We will also report on the first offering of the redesigned course and remark on future improvements. [ABSTRACT FROM AUTHOR]

Copyright of Proceedings of the ASEE Annual Conference & Exposition is the property of ASEE and its content may not be copied or emailed to multiple sites without the copyright holder's express written permission. Additionally, content may not be used with any artificial intelligence tools or machine learning technologies. However, users may print, download, or email articles for individual use. This abstract may be abridged. No warranty is given about the accuracy of the copy. Users should refer to the original published version of the material for the full abstract. (Copyright applies to all Abstracts.)