浅谈VBA在监测数据处理中的应用

Application of VBA in Monitoring Data Processing

Excel、Word以及Power Point已经成为了当前办公软件的首选。而其中Excel对处理数据的能力是非常强大的,但是只有很少人使用VBA开发功能。使用VBA能让Excel处理数据的过程更加简便有效。简易的小型VBA程序可以自动完成多数的日常工作。本文从实际出发,介绍了轻量级VBA应用程序的开发过程,结合监测工作数据处理的实际需要,展示了VBA在处理广播电视监测资料方面的优势。

Excel, Word and Power Point have become the i rst choice of oi ce software. Especially, Excel is a powerful application in processing data, but only a few users have used the VBA component of Excel. The work will become easier if the VBA program is used in daily work. A few lines of VBA script can do routine work automatically. In this paper, we discuss how to write a small application using VBA component of Excel which can help process the data of monitoring TV and radio programs.