基于VBA应用的横河CS3000DCS系统数据采集的二次研发

Application of VBA Henghe CS3000 DCS data acquisition system based on the two R & D

VBA,Visual Basic for Applications是Visual Basic的一种宏语言,具有很好的利用环境。目前不仅仅是Microsoft Office办公软件支持VBA,AUTOCAD、WPS Office、Coreldraw等应用软件均支持VBA。了解和掌握VAB,可解决办公软件或者DCS系统应用问题。本文简单介绍了VBA概念,横河DCS特点。并通过横河DCS CS3000VP/NET论述,以VBA和横河DCS命令相结合,读取趋势数据生成数据报表为例,对DCS系统二次开发解决生产问题,旨在让读者了解有关VBA原理、横河DCS常用组态方法和应用的基本原理,抛砖引玉,在解决其它设备间通讯问题时提供方法。

VBA, Visual Basic for Applications Visual is a Basic macro language environment, has the very good use of. At present, not just the Microsoft Office office software supports VBA, AUTOCAD, WPS Office, Coreldraw and other application software support VBA. Understand and grasp the VAB, which can solve the problems of office software or DCS system application. This paper simply introduces the concept of VBA, the characteristics of Henghe DCS. And through the Henghe DCS CS3000VP/NET was discussed, combined with VBA and the Henghe DCS commands, read the trend data to generate data report as an example, on the DCS system two development and solve problems in production, in order to find out about the VBA principle, Henghe DCS common configuration method and application of the basic principle, offer, provide method in solving the communication problem of other equipment room.