vb中excel的引用（Reference to excel in VB）.docVIP

vb中excel的引用（Reference to excel in VB） VB2005 how to output the data into Excel statements VB is one of the commonly used application development tools, because the reporting function of VB is limited, but the report format changes, you must modify the program corresponding to the application software maintenance inconvenient. There are so many programmers now make full use of the powerful function of EXECL to report the report function. But because VB and EXCEL are due to belong to different applications, how to combine them, is a subject worthy of our study. A, VB read and write the EXCEL table: VB itself provided automation function can read and write the EXCEL table, the method is as follows: 1, in the engineering reference Microsoft Excel type library: From the Project menu reference column; Microsoft Excel 9 Object Library (EXCEL2000), and then choose ok. That references to the EXCEL type library in the project. 2, in general the declaration of objects defined in the EXCEL object: Dim xlApp As Excel.Application Dim xlBook As Excel.WorkBook Dim xlSheet As Excel.Worksheet 3, in the process of operation of EXCEL commands: Set xlApp = CreateObject (Excel.Application) create a EXCEL object Set xlBook = xlApp.Workbooks.Open (file name) open book EXCEL part file already exists XlApp.Visible = True (EXCEL set object is visible or invisible) Set xlSheet = xlBook.Worksheets (table) set the active worksheet XlSheet.Cells (row, Col) = value to the cell (row, Col) assignment XlSheet.PrintOut print worksheet XlBook.Close (True) close the workbook XlApp.Quit end of the EXCEL object Set xlApp = Nothing release of xlApp objects XlBook.RunAutoMacros (xlAutoOpen) EXCEL operation start macro XlBook.RunAutoMacros (xlAutoClose) EXCEL running off Acer 4, in the use of the above VB EXCEL command operation table, unless a EXCEL object is not visible, otherwise the VB program can continue to perform other operations, can also turn off EXCEL, but also can operate on EXCEL. But close the