Excel 2000在公路工程项目经济评价中的应用

Application of Excel 2000 to Economic Evaluation of Highway Projects

阐述了如何利用Excel2000VisualBasic语句访问Excel中工作表的Range对象、表格行和列对象等,以及如何利用Excel工作表常用的事件进行编程等问题。以一个公路工程项目经济评价实例说明了在Excel2000中使用VisualBasic编程。

This article describes how to use Excel 2000 Visual Basic's commands to access the objects of Range, Row and Column in the Excel worksheet, and how to use the typic events in the Excel worksheet to programme. Also, it uses one example of the economic evaluation of the highway project to describe how to use VB to programme in Excel 2000 in details.