reference to excel

[mhpo]

Hi,

Im trying to access Excel-cells. Therefor I added a reference to the installed Excel 8.0 Object Library.

Here is my .NET-code:

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, the following error-message occurs:
Old format or invalid type library

Does someone know, whats going wrong ??

 

[geonaf]

Hello, mhpo, did I am experiencing the same problem. Did u find anything out? If so please let me know, thank u in advance.

 

[mhpo]

ooohhh yes - at long last I have the solution :

So please read the article in the MSDN:

http://support.microsoft.com/default.aspx?scid=kb;en-us;320369

Greetings

mhpo

 

[geonaf]

ok, got it, thanx!!