关键词: VBA Excel OLE实时 OCX

Abstract:

The Low-Voltage Power Monitoring System is a real-time data monitoring system, which can construct a report following the customers＇ requirements, bu  t its spreadsheet usually adopts the traditional design form. This design mainly has two problems. One of them is that it just satisfies the users＇ sta atic requirements , while the other one is that it usually uses the report tools which belong to the development environments and these tools always realize only the regular report definition. In this paper, we discuss the deficiency of the dissatisfactory dynamic requirements in conventional spreadshee t design, and finally present a customer-oriented technology which can realize Excel control with OLE and Vt3A to actualize the report. And then the use  rs can customize the report＇ s format and data to realize all kinds of regular and irregular reports which can meet the users＇ dynamic needs.

Key words: VBA, Excel;OLE, real- time ;OCX