vb中Excel的引用（国外英文资料）.doc

vb中Excel的引用（国外英文资料） How does VB2005 become an Excel report VB is one of the commonly used application software development tools, due to the limited VB reporting features, and a report format changes, have to modify the program, corresponding to the application software maintenance work inconvenient. As a result, many programmers have now made full use of EXECLs strong report work to implement reporting capabilities. But because VB and EXCEL are part of different application systems, how to combine them organically is a topic worth studying. VB reads and writes EXCEL table: VB itself can read and write EXCEL tables with automated functions: Reference the Microsoft Excel type library in the project: Select the reference column from the project menu; Select Microsoft Excel 9.0 Object Library (EXCEL2000) and select fix. The EXCEL type library is referenced in the project. Define EXCEL objects in the general object declaration process: Dim xlApp As Excel Application Dim xlBook As Excel WorkBook Dim xlSheet As Excel Worksheet To operate EXCEL tables in your program: Set xlApp = CreateObject ( Excel. Application ) creates an Excel object Set xlBook = xlapp.workbooks. Open ( filename ) opens the existing EXCEL workbook file Xlapp.visible = True sets the EXCEL object Visible (or invisible) Set xlSheet = xlbook.worksheets ( table name ) sets the activity worksheet The xlSheet Cells (row, col) = value assigns the cell (row, col) XlSheet. PrintOut print worksheet The xlbook.close (True) closes the workbook Xlapp.quit finishes the EXCEL object Set xlApp = Nothing release xlApp object Xlbook.runautomacros (xlAutoOpen) runs EXCEL to start macros Xlbook.runautomacros (xlAutoClose) runs EXCEL to close the macro More than 4, the use of VB command operation EXCEL table, unless set EXCEL object is not visible, otherwise the VB program may continue to perform other operations, can also close the EXCEL, also may carry on the operation of the EXCEL at the same time. But when you close t