+18 | Play Responsibly | T&C's Apply | Commercial Content | Publishing Principles

Library Download Vb6 | Microsoft Excel 12.0 Object

' Do something xlSheet.Cells(1, 1).Value = "Hello from VB6"

' Clean up Set xlSheet = Nothing xlWB.Close False Set xlWB = Nothing xlApp.Quit Set xlApp = Nothing Microsoft Excel 12.0 Object Library Download Vb6

This allows your VB6 program to work with any installed version of Excel (2000 through 365) without needing a specific library reference. ' Do something xlSheet

' Add a workbook Set xlWB = xlApp.Workbooks.Add Set xlSheet = xlWB.Worksheets(1) ' Do something xlSheet.Cells(1