BA在Excel 97中的一个应用

An Application of VBA in the Excel 97

简要介绍了MicrosoftExcel97的强大数据处理功能以及宏功能。讨论了为什么要把VBA嵌入到Excell97中,以及利用VBA来创建Excel97宏的方法。由于VBA没有提供硬件级的控制语句,如读写硬件端口等,因此给出了利用VC++5.0制作DLL文件,以及如何在VBA中调用DLL文件以读取端口数据的方法。介绍了一种直接利用Excel97的宏命令进行数据采集和显示的方法,利用Excel97强大的数据处理功能对所采集的数据进行处理和分析。并说明了VC++5.0中DLL文件的编写方法。最后通过运行宏,实现了Excel97中的数据采集和显示这一应用目的。

This article introduced the strong data process and macro function of Microsoft Excel 97. It discusses why VBA is added to Excell 97, and the way to create Excell 97's macro. As VBA do not offer the control sentence in hardware level such as reading or writing the hardware port and so on. It gave a method of making DLL files and calling DLL files to read the port data in VBA by VC++5.0. It introduced a method to select and display data by using Macro order of Excel 97 directly in order of using the strong data processing function of Excel 97 to process and analyses the data collected. It illustrated the method to make up DLL files in VC++5.0 and how DLL files can be called in VBA. At last it realized the application to collect and display data in Excel 97 by running macro.