Application and research of VBA processing hydrology data in Excel
Niu Gui-zhi · Journal of Waterway and Harbor · 2008
VBA is characterized by its simplicity,flexibility and powerful function,and it has become the important method of engineering calculating,data processing and data alternating presently.The processing of hydrology data,the format of the final data and the reasonable statistics of a great deal of report forms are introduced in this paper on the basis of VBA processing hydrology data in Excel,and VBA with Excel,file with file interactively,the management technology of data are mainly discussed.The practice shows that it is can realize the treatment of mass hydrology data with the parameters auto-setting based on the development of VBA in Excel.The speed of operation is greatly increased finally.