Office Upgrade causing build problems on VB project

[tmar]

We recently upgraded from Office 2003 to Office 2010. Once this was installed on my development machine I get errors on my build due to the program no longer recognizing the Excel namespace. There are errors throughout the program but they are on statements like the ones below where I'm referring to the Excel namespace.

Dim excel As New Microsoft.Office.Interop.Excel.ApplicationClass
Dim wBook As Microsoft.Office.Interop.Excel.Workbook
Dim wSheet As Microsoft.Office.Interop.Excel.Worksheet

I've tried removing and re-establishing the reference to Excel. I've reinstalled the office 2003 interop. I've even reinstalled VB on the machine but none of these steps worked.

Any ideas?

 

[jebenson]

What are the errors?

I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson

Arrrr, mateys! Ye needs ta be preparin' yerselves fer Talk Like a Pirate Day!