Excel VBA技术在中小制造企业信息管理系统中的应用  

Application of Excel VBA technology in the information management system for small and medium manufacturing enterprises

作　　者：王俊飞[1] 唐克岩[1] 向渝[1] 陈伟 Wang Junfei;Tang Keyan;Xiang Yu;Chen Wei(College of Engineering ＆ Technical,Chengdu University of Technology,Sichuan Leshan,614000,China;Shanxi Zhonggu Electronics Co.,Ltd.,Shanxi Taiyuan,030024,China)

机构地区：[1]成都理工大学工程技术学院,四川乐山614000 [2]山西中谷科贸有限公司,山西太原030024

出　　处：《机械设计与制造工程》2018年第8期81-86,共6页Machine Design and Manufacturing Engineering

基　　金：成都理工大学工程技术学院青年基金资助项目(C122016019)

摘　　要：目前中小制造企业存在信息分布散乱、缺乏集成化、无法实现信息实时共享等问题,基于此情况,依托通用办公软件Excel 2007平台利用其内嵌VBA进行二次开发,并综合应用数据库技术和Web网络技术,构建了一站式集成化信息管理系统。实践表明,该系统可实现企业信息自动化、网络化管理,实现了信息的实时共享。At present,small and medium manufacturing enterprises have these problems such as scattered information distribution,lack of integration,unable to realize real-time information sharing,In view of this situation,it builds a one-stop integrated information management system,uses the embedded VBA and common office software Excel 2007 platform,combines the application of database technology with web networking technology to develop the system.Practice shows that the system can realize the enterprise information automation and network management,and make the real-time information sharing.

关 键 词：中小制造企业 集成化 EXCEL二次开发 VBA 信息管理 

分 类 号：TP311.52[自动化与计算机技术—计算机软件与理论]