Preliminary Study On Communicative Canal-Aid-Designing System Base On ExcelVBA Programing Technology

The study is based on the amount of land development and consolidation project to complete the tasks of the program. It mainly adopte ExcelVBA program which can control design forms and generate,used in AutoCAD drawing.The interaction can solve the complex problem between data editing in Excel and drawing in AutoCAD in the channel design, The ExcelVBA program can save time and speed, increase efficiency in design and drawing of channel.In the channel computer-aided design, the study use the ExcelVBA program to control and automatically generate the channel design forms, which can satisfy requirements of the designers, and directly caculate hydraulic element in the forms.Sametime,the ExcelVBA program automatically create the design results through linking the data of the forms.Thus, it can reduce course of artificial operation forms. In the channel design drawing ,the ExcelVBA can geniously use interactive operation to solve the program between the data (the Scr files )of Excel design and AutoCAD drawing ,which bridge the data conversion and the graphics editor, greatly improving efficiency of the design drawing.For ExcelVBA in development of channels computer-aided design, some designers study and applycation mostly based on AutoCAD drawing and technique Excel, no systematic software of computation. The thesis also try to study forward the applycation of ExcelVBA and AutoCAD drawing to solve easily problems in channel design. As a further discussion, it also existing some programs, for example, the encryption function, the transect of other channel forms , the optimization of design method and drawing, and so on.But with the deepening study and applycation of the program will gradually improve its function. Overall, using computer-aided design program can short design cycle, low cost, easy to modify for personal designers or design of small business unit.