主要介绍了以Excel为基础通过VBA程序关联AutoCAD和Word的喷漆线设备规划与提资系统,其能达到涂装车间喷漆室、空调、工作区等相关设备计算书、电控提资及公用耗量、流程图、技术参数表的连通,实现“数出一源、多点共享、准确高效”的效果。文中描述了其规划思路、各模块构成和功能,供相关设计人员参考。

This article introduces a painting line equipment planning and data collection system based on Excel and associated with AutoCAD and Word through VBA programs.It can achieve the connection of equipment calculation sheets,electric control data collection,public consumption,flow charts,and technical parameter tables in painting workshops,such as painting rooms,air conditioners,and work areas,to achieve the effect of"counting one source,multi-point sharing,accuracy and efficiency".The article describes its planning ideas,composition and functions of each module for reference by relevant designers.