利用VBA程序语言绘制公路纵断面图.rar

利用VBA程序语言绘制公路纵断面图

1 前言
纵断面设计图是道路纵断面设计的主要成果，也是道路设计的重要技术文件之一。在纵断面设计图上有两条主要的线：一条是地面线，它是根据中线上各桩点的高程而点绘的一条不规则的折线，反映了沿着中线地面的起伏变化；另一条是设计线，它是经过技术上、经济上以及美学上等多方面比较后定出的一条规则形状的几何线。
公路设计中，在没有专业设计软件辅助的情况下，绘制公路纵断面图是很繁琐的事，需要进行大量的、重复的操作，既劳神，又容易出错。特别在公路外业勘测阶段，需要在短时间内将所测量的中桩高程转化成纵断面图上的地面线，才可以进行路线纵坡设计，分析测量成果（选线）是否合理。
如何快速绘制公路纵断面地面线呢？答案是：利用Microsoft Excel、AutoCAD都提供的VBA功能，编制程序进行绘制，即把Microsoft Excel表格中的桩号、地面高程等信息读取出来，在AutoCAD文件里以文字、线条的方式写出来，就可绘出中桩地面线。
2 VBA简介
Visual Basic for Application（VBA）是Microsoft面向最终用户的应用软件编程语言。它最早出现于Microsoft的Excel和Project中，如今VBA已成为VB和所有Office产品的组件。常用的绘图软件AutoCAD也已支持VBA作为二次开发工具。
VBA最大特点和最大优点是利用面向对象（OOP）的ActiveX Automation技术，使语言的引擎在技术上与开发环境分离。它的功能在很大程度上依赖于它的客户显露的Automation接口。同时，由于VBA是基于ActiveX Automation技术，它可以使用任何Automation技术的应用程序共同工作。
基于AutoCAD的VBA应用程序就是高级
Using VBA programming language mapping Lengthwise Section of Highway

1 Introduction
Profile Design Profile Design road map is a major achievement, the importance of road design technology is one of the documents. In the longitudinal design, there are two main lines: one is the ground line, it is based on the online point of the pile height and plotting of an irregular line, reflecting the ups and downs along the middle ground; another the design line, which is the result of technology, economy and aesthetics superior set after many compare the geometric shape of a rule line.
Highway design, the design of software supporting the no professional under the circumstances, draw highway profile chart is cumbersome for Shi, requires a great deal of, Zhong Fu's Cao Zuo, Ji trouble, prone to error. Outside the industry, particularly in the investigation phase of road needs to be measured in a short time in the pile into a longitudinal elevation map of the ground line, it can route longitudinal design and analysis of measurement results (selected line) is reasonable.
How to quickly draw the line on the road surface highway profile? The answer is: using Microsoft Excel, AutoCAD VBA functions are provided, the preparation process to draw, that the Stake Microsoft Excel table, ground elevation and other information to read out a text file in AutoCAD, the line the way to write out ground lines can be drawn in the pile.
2 VBA Introduction
Visual Basic for Application (VBA) is Microsoft's application software for end-user programming language. It first appeared in Microsoft's Excel and Project, now VB and VBA has become the components of all Office products. Commonly used mapping software also supports AutoCAD VBA as a secondary development tools.
VBA is the most features and greatest advantage of using object-oriented (OOP) in the ActiveX Automation technology to the language engine technology and development environment in isolation. It features a large extent dependent on its customers revealed the Automation Interface. Also, because VBA is based on the ActiveX Automation technology, it can use any of Automation technology applications to work together.
Applications based on AutoCAD's VBA is the senior