Hi,
Im trying to access MS Excel-cells with VB .NET. Therefor i implemented a reference to the installed Excel 8.0 Object Library. So far the Excel-Objects can be referenced. The following code attempts to write data to the cells:
Dim xlApp As Excel.Application
Dim xlMappe As Excel.Workbook
Dim xlZelle As Excel.Range
xlApp = New Excel.Application()
xlMappe = xlApp.Workbooks.Open("C:\KK.xls")
xlZelle = xlMappe.Worksheets(1).Range("A1")
xlZelle.Value = "content"
When it runs, this error-message occurs:
Old format or invalid type library
Whats going wrong ??
Im trying to access MS Excel-cells with VB .NET. Therefor i implemented a reference to the installed Excel 8.0 Object Library. So far the Excel-Objects can be referenced. The following code attempts to write data to the cells:
Dim xlApp As Excel.Application
Dim xlMappe As Excel.Workbook
Dim xlZelle As Excel.Range
xlApp = New Excel.Application()
xlMappe = xlApp.Workbooks.Open("C:\KK.xls")
xlZelle = xlMappe.Worksheets(1).Range("A1")
xlZelle.Value = "content"
When it runs, this error-message occurs:
Old format or invalid type library
Whats going wrong ??