基于VBA自动提取坐标插件的设计及在±0验线中的应用

摘要

Engineers usually extract and output the coordinates based on topographic map or CAD map. A few coor-dinates can be finished artificially. However,if a lot of special coordinates are needed,( such as when making the form of ±0 checking coordinate minus,the feature point should be collected and output)the artificial work is unsatisfactory. The article represented the auto-generated method of the plug-in and its application using VBA. According to this idea,engi-neers could make many more plug-ins of coordinate automatic extraction deriving from this program.%测绘工作中有很多情况下是需要根据地形图或者CAD图提取需要的坐标并列表输出，少量的点可以人工完成，但是对于有特殊要求或者大量的点，比如在±0验线内业工作“验线较差表”的编制作业中就经常需要采集特征点的坐标值并列表输出，手工操作就差强人意了。本文主要阐述采用VBA编程方法有效解决有固定样式表格编制中坐标值自动写入插件的设计和实际运用，灵活运用此编程的思路，可以衍生很多符合实际工作需要的坐标自动提取输出的插件。