using excel in .NET problems

[stx]

Hi

This is my code:
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim oXL As Excel.Application
Dim oWB As Excel.Workbook
Dim oSheet As Excel.Worksheet

' Start Excel and get Application object.
oXL = CreateObject("Excel.Application&quot
oXL.Visible = True

' Get a new workbook.
oWB = oXL.Workbooks.Add
oSheet = oWB.ActiveSheet

' Add table headers going cell by cell.
oSheet.Cells(1, 1).Value = "First Name"
oSheet.Cells(1, 2).Value = "Last Name"
oSheet.Cells(1, 3).Value = "Full Name"
oSheet.Cells(1, 4).Value = "Salary"

' Format A11 as bold, vertical alignment = center.
With oSheet.Range("A1", "D1&quot
.Font.Bold = True
.VerticalAlignment = Excel.XlVAlign.xlVAlignCenter
End With
End Sub

I got this code from the microsoft website:

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

I'm running visual studio.NET 2003 on a windows xp pro system with office xp pro on it.
I added the necessary references to my project.
(com reference to excel 10.0 library)

The following error is what i get:
Old format or invalid type library.


I already re-installed my office xp but that resolved nothing.

I'm getting very desperate.

Anyone any thoughts.
Any help is welcome.
Thnx.

 

[benlinkknilneb]

There's also an Office library that's separate from the Excel 10 library; I don't know if that would make a difference or not...

 

[stx]

Thnx for the reply benlinkknilneb

No, adding the office library doesn't change a thing.

At the followong line of code i still get the same error:
oWB = oXL.Workbooks.Add


Any thoughts?
please!

thnx

 

[benlinkknilneb]

I'm not sure why it doesn't work, but the syntax you're using is the old method for opening an excel document. I was under the impression that it would still work. Here's the way I've done it:

Dim xlapp As New Excel.Application()
Dim xlbook As Excel.Workbook
xlbook = xlapp.Workbooks.Open(PathToExcelFile)

Of course, that opens an existing doc for editing... but I was thinking more about the declarations. Try changing your declarations to the above rather than using the CreateObject() function.

 

[stx]

benlinkknilneb

i used your 3 lines of code and i got the same error message as before on the last line !

Error:
Old format or invalid type library.

Any thoughts

thnx for replying

 

[stx]

Thnx for the effords guys but found the problem myself.

It is a bug in microsoft office.

visite following link to microsoft site for resolution:

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

 

[benlinkknilneb]

<big grin> Don't you love it when you can blame Microsoft?