- on Microcontrollers
- Published in issue 5/2000 on page 0
Measuring in Word and Excel
using Visual BASIC for Applications
Microsoft Office 97 includes a complete programming language called Visual BASIC for Applications (VBA). With this interpreter, which is largely compatible with Visual BASIC, it is possible to perform measurements directly in Word or Excel. The full power of the Office applications is then available for analysing the measured values. Since VBA can address external routines in dynamic link libraries, it is possible to directly import measurement values.Nowadays, an RS232 interface is a standard feature of any better than average multimeter. However, the accompanying software can usually only display a series of measurements on the PC monitor or save the data as a text file. If you want to further process and evaluate the measurements, this tabular text file must be laboriously transformed using a statistical program or imported into a word processor.