|
|||||
|
|
| 利用VBA实现FactoryTalk View SE报表功能 | |
| 引用本文： | 康英,辛亚军,刘志远,王圣齐.利用VBA实现FactoryTalk View SE报表功能[J].电气传动自动化,2011,33(5):47-48,56. |
| 作者姓名： | 康英 辛亚军 刘志远 王圣齐 |
| 作者单位： | 1. 西安利雅得电气股份有限公司,陕西西安,710075 2. 青海桥头铝电股份有限公司,青海大通,810100 3. 新疆独山子石化公司热电厂,新疆克拉玛依,833600 |
| 摘 要： | FactoryTalk View SE是组态软件,在数据监控、画面显示等方面具有强大的功能,然而在报表处理方面却表现出弱点.利用其内嵌的VBA可以扩展软件功能.介绍了结合FactoryTalk View SE内嵌的VBA,通过ODBC接口读写Access中的数据,然后调用Excel生成报表的方法. |
| 关 键 词： | 报表 Excel VBA FactoryTalk View SE Acces |
Using VBA to achieve the FactoryTalk View SE reporting function |
|
| KANG Ying,XIN Ya-jun,LIU Zhi-yuan,WANG Sheng-qi.Using VBA to achieve the FactoryTalk View SE reporting function[J].Electrical Drive Automation,2011,33(5):47-48,56. | |
| Authors: | KANG Ying XIN Ya-jun LIU Zhi-yuan WANG Sheng-qi |
| Affiliation: | 1(1. Xi’an Leadi Electric Automation Co.,Ltd.,Xi’an 710075,China;2.Qinghai bridge Aluminum Co.,Ltd.Datong 810100,China;3.Xinjiang Dushanzi Petrochemical Company Thermal Power Plant,Karamay 833600,China) |
| Abstract: | FactoryTalk View SE is one kind of configuration software,which has powerful features in the data monitoring,screen displaying and son on,but has the weakness in reporting process.Using in-line VBA to extend its software function.Combining with in-line VBA,via ODBC interface to read and write data in access,and then using Excel to generate reports. |
| Keywords: | report Excel VBA FactoryTalk View SE Access |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ | |