Excel与CAD相结合，运用VBA语言编程，提出了一种自动绘制工程施工平面图的方法，给出了程序的思路图和主程序。改方法充分考虑了与用户进行交互的问题，大大减小了受Excel固定表格约束的影响，使程序更具有人性化特点。-The combination of Excel and CAD, the use of VBA programming language, proposed an automatic method of drawing the construction plans, the program gives the idea of ​ ​ figure and the main program. Change methods take full account of the problems interacting with the user, which reduces the fixed form by the constraints of Excel, make the program more user-friendly features.