Excel VBA在集团企业基层信息化建设中的应用

Application of Excel VBA in the Information Construction of Grassroots Units in Group Companies

目前,企业信息化建设的程度已普遍较高,尤其是大型集团企业,更是普遍应用了相应的管理信息系统,提高了自身的管理水平。但是对于集团企业下属的基层企业而言,仍然存在无法通过管理信息系统满足的需求。笔者分析了集团企业的基层企业在信息化建设中存在的问题及原因,介绍了Excel VBA的优势,并给出了利用Excel VBA来解决上述问题的思路。

Currently,the extent of enterprise information construction has been generally higher.Large group companies generally implemented the corresponding management information system,to improve the level of their management.However,for the grassroots units of the group companies,there are some demands that cannot be met through the management information system yet.The author analyzes the problems and reasons of the information construction of grassroots units in group companies,introduces the advantages of Excel VBA,and gives the idea of using Excel VBA to solve the problems above.