It's important to clarify a common point of confusion:
Dim xlApp As Object Dim xlWB As Object Dim xlSheet As Object ' Create Excel instance (no reference needed) Set xlApp = CreateObject("Excel.Application") xlApp.Visible = True Microsoft Excel 12.0 Object Library Download Vb6
Newer versions are backwards compatible. If you have Office 2010, 2013, 2016, 2019, or 365, reference the latest library you see (e.g., 16.0). Your code will still work with older Excel files. It's important to clarify a common point of
' Do something xlSheet.Cells(1, 1).Value = "Hello from VB6" Microsoft Excel 12.0 Object Library Download Vb6
' Add a workbook Set xlWB = xlApp.Workbooks.Add Set xlSheet = xlWB.Worksheets(1)