CONSTRUCTION AND UPDATE OF INDUSTRY DATABASE BASED ON VBA

Xu Xingjun,Yan Gangfeng
DOI: https://doi.org/10.3969/j.issn.1000-386x.2012.11.056
2012-01-01
Abstract:In order to improve the efficiency of updating the webpage data of Excel-based industry database which is frequently used in financial industry,a common database structure is defined.The localisation of company's position in database,the generation of target website and the acquisition of the targeted data are implemented based on VBA.The chart update is achieved at the same time while the data is updating.Furthermore,the data updated has been statistically analysed for pick up useful information.Comparing the time consumption of the automatic database update with that of the manual database updated,it shows that automatic data updating greatly improves the efficiency of updating rate of the database and has very high commercial value.
What problem does this paper attempt to address?