摘要
VBA全称Visual Basic for Applications,可以实现EXCELL表格与WORD文档等数据编写、筛选、处理等一系列功能。在实际应用中可以提高文档制作效率,降低数据处理过程中的错误率。该设计利用其便捷的功能,针对某油田复杂的报表进行自动化改良,其中实现了数据的自动计算、自能筛选,报表的一键生成等功能,最终实现报表的自动化制作。
The full name of VBA is Visual Basic for Applications.It can achieve screening,processing when using excel tables and WORD documents or other data preparation.In practical application,the efficiency of document could be improved,the error rate could be reduced.This design makes use of its convenient functions to improve the complex statements of an oil field automatically,which realizes the functions of automatic calculation of data,self-energy screening,one-key generation of statements,and finally realizes the automatic production of statements.
作者
喻靖
朱峰
夏瑞杰
YU Jing;ZHU Feng;XIA Rui-jie(CNOOC,Tianjin 300110,China)
出处
《价值工程》
2020年第9期193-194,共2页
Value Engineering
