【摘要】 农业信息资源建设过程中,经常会遇到批量查找、替换和标注等重复性强且繁琐的操作,自动化语言VBA作为一种与微软办公套件可以协同工作的工具,可以成为农业信息资源建设过程中采集、编码和审核等重要环节的得力助手。通过探索VBA在农业信息采集、整理、加工中的应用,以实例的方式展示了VBA协助不同格式农业信息的快速整理、格式的统一和禁用农药的批量查找和标注,提高农业信息整合的工作效率和质量的应用。更多还原

【Abstract】 Repeated and tedious operations such as searching,replacing and marking are reprehensive in the process of agricultural information resource development.This paper proposes two typical applications of VBA,the Microsoft’s Automated Language to perform the operations of format clearing and the forbidden pesticide identification.The comparison has shown that the VBAas a useful toolkit can leverage the working efficiency of the message collecting,coding and auditing processes,as well as information quality significantly.更多还原