using excel in VB.NET

[stx]

I'm using a windows xp pro system with visual studio.net 2003 and microsoft office xp.

This is my code

Dim oXL As Excel.Application
Dim oWB As Excel.Workbook
Dim oSheet As Excel.Worksheet

oXL = CreateObject("Excel.Application&quot
oXL.Visible = True

oWB = oXL.Workbooks.Add

The last line of code is where i get following run-time error:
Old format or invalid type library

I have added a com reference to microsoft excel 10.0 object library.

Anyone had the same problem?
Any help would be very appreciated.

thnx

 

[PankajBanga]

visit the following link

Automate Microsoft Excel from Visual Basic .NET

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