摘要
笔者根据多年的工作经验,结合具体实例探讨了Excel内置开发工具VBA(Visual Basic for Application)在实际工作中的应用技巧,解决了在数据处理过程中繁杂的操作步骤和大量数据的数学计算,有效杜绝了人工操作带来的错误。
Based on work experiences in many years,combining with actual examples,application method and techniques of VBA(Visual Basic for Application)which is the inner couplers developing tool of Excellhave been studied.Mathematics calculation with complicated operation steps and a great deal of datas in the process have been solved.It will effectively eradicate mistakes brought by artificial operation.
出处
《山东国土资源》
2014年第8期80-84,共5页
Shandong Land and Resources
关键词
VBA
数学模型
算法
三角函数
潜力评价
VBA
mathematical model
arithmetic
trigonometric function
capacity evaluation