| 基于VBA的Excel常用测量函数开发 |
| |
| 引用本文： | 王少文,LI Jian.基于VBA的Excel常用测量函数开发[J].北京测绘,2008(2):47-49. |
| |
| 作者姓名： | 王少文 LI Jian |
| |
| 作者单位： | 广州市房地产测绘所,广东广州,510030 |
| |
| 摘 要： | 基于VBA开发Excel测量程序具有简便、高效和通用的特点。考虑到参考文献一中已经比较详细地介绍了VBA在Excel中的开发技术,本文将介绍利用VBA在Excel中开发几个常用测量函数的实例,深入地剖析用度分秒表示的角度与用弧度表示的角度之间的相互转换和坐标方位角反算三个VBA函数,并提供了VBA源代码,供同行借鉴与直接使用。
|
| 关 键 词： | VBA EXCEL 测量 函数 |
| 修稿时间： | 2007年12月17 |
Development of Surveying Functions with Excel based on VBA |
| |
| HU Da-guo,LI Jian.Development of Surveying Functions with Excel based on VBA[J].Beijing Surveying and Mapping,2008(2):47-49. |
| |
| Authors: | HU Da-guo LI Jian |
| |
| Institution: | HU Daguo, LI Jian( 1.Real Estate Surveying and Mapping Institute of Guangzhou Municipality, Guangzhou, Guangdong, 510030; 2. The Surveying＆ Designing Institute of Xin jiang Production and Construction Corps, Urumehi, Xinjiang, 830002) |
| |
| Abstract: | The surveying programs developed with Excel based onVBA has convenience,high efficiency and wide application characters.The development of such programs has been generally introduced in the reference 1 and this paper introduces several surveying functions developed with Excel based on VBA and the relative detailed application examples.Meanwhile,this paper discusses how to use degrees,minutes,seconds to represent angles,and how to use radians to represent angles,and how to realize the conversion between them,and how to realize coordinates azimuth inverse calculating.Furthermore,this paper offers the source codes of these three VBA functions. |
| |
| Keywords: | VBA Excel |
| 本文献已被 维普 万方数据 等数据库收录！ |
|
