基于Visual Basic与EXCEL相结合的问题研究

The research on problems of unify based on Visual Basic and EXCEL

本文研究了如何实现Visual Basic与EXCEL的结合,由此弥补Visual Basic的报表功能有限的缺憾.研究如何通过引入COM组件来解决Visual Basic与EXCEL分别属于不同的应用系统的问题,使二者优势互补达到Visual Basic完全控制EXCEL的目的.

This article study emphatically realizes Visual Basic and the EXCEL union,from this makes up Visual Basic the report form function limited disappointment.How studies through to introduce the COM module to solve Visual Basic and EXCEL belongs to the different application system＇s question separately,enables the two survival of the fittest to achieve the goal ofVisual Basic to control EXCEL completely.