About the article

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.
Downloading of this magazine article is reserved for Elektor Members only.
Already a member? click here to log in.
Loading comments...