基于VBA的ActiveX控件多关键字查询技术  

VBA-based ActiveX control multi-keyword query technology

作　　者：蒋正茂[1] Jiang Zhengmao(School of mechanical engineering Sichuan University,Chengdu,Sichuan 610065,China)

机构地区：[1]四川大学机械工程学院,四川成都610065

出　　处：《计算机时代》2020年第4期4-6,共3页Computer Era

摘　　要：应用办公系统时,常常需要在其他Excel文档中获取数据填写在新报表中。为了高效和准确地完成任务,基于Excel办公软件的普及化现状,提出基于VBA的ActiveX控件表达和Worksheet事件触发实现多关键字查询技术,实现从其他Excel工作表中获取数据并填写到新报表的工作。When using the office system, it is often necessary to obtain data from other Excel documents and fill in the new report form. In order to complete the task efficiently and accurately, and in view of the popularization of Excel office software,this paper proposes to realize multi-keyword query technology by using VBA ActiveX control and worksheet event trigger, so as to implement the work of obtaining data from other Excel worksheets and filling in the new report form.

关 键 词：VBA 多关键字 数据处理 ACTIVEX 

分 类 号：TP3[自动化与计算机技术—计算机科学与技术]