reference to excel

[mhpo]

Hi,

 

I'm 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, what's 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!!