Cad Technology Combined With Vba In Highway Engineering

CAD technology has played an irreplaceable role in engineering design for its advantages such as simplicity, convenience, and easy storage during years of practice. Although the application of CAD technology greatly enhances the efficiency of designers, some shortcomings arise. VBA being a compositive develop environment can achieve direct share between AutoCAD data and other VBA applications such as Microsoft Excel.CAD technology (Computer Aided Design) refers to the practical technology mediated by computer the aid the engineer during the design process. CAD technology is most widely used in two or three dimensional geometric modeling, plotting, mechanical accessory design, circuitry design, architecture design and mechanics analysis, etc.CAD as a knowledge began in the 1960's, and developed slowly for the constrains of computer technology until the end of 1970's. in the 1980's, CAD became practical for the popularity of micro computer and stations, and it served diffusely in mechanism, electronics, astrionics and spinning.CAD now is applied in all areas concerns design and manufacture in industrial society such as USA, European and Japan. The sale of CAD increases by 30% to 40% each year and the functions of the CAD software become more and more powerful. The implementation of CAD technology in China has been quite productive since the end of 1970's.VBA(Visual Basic for Application)is an absolute object-oriented programming language, and many applications embeds this language as a developing tool for its simplicity and powerful functions. Autodest Corporation embedded VBA into CAD since version R14.01 as well as provided ActiveX Automation object model which is adapted to VBA developing. VBA is a universal automatic language for implications developed by Microsoft, which can be regarded as a subcategory of the popular programming language Visual Basic.This article introduces the concept of CAD and VBA as well as their functions. It also elaborates how to build up communications between AutoCAD 2002 and Excel 2000 to achieve data exchange; how to plot road desighing efficiently and how to convert an Excel table into an AutoCAD table.