基于VB和Excel宏快速开发软件

Excel has convenient data input and powerful data processing ability, its function of editing, formatting, design and printing both provide a perfect solution. VB(Visual Basic) is a programming language with a strong general-purpose. It provides a good condition to develop programs easily and quickly, and effectively programs interfaces. Some applied programs can be developed with VB. It has rapid running speed and its practicality and security are ideal. It focuses on the topics of how to exchange data between VB and Excel so that we can make full use of the advantages of both to serve the users. And it takes the development of program which applies for standardizing table format as example, the whole process of developing this software by excel macro is described.