[RESOLVED] Cannot find wrapper assembly for type library Excel

This works fine at home but at work when i add the reference to the Microsoft Excel 11.0 Object Library it gets the error on the yellow icon in the screen shot.

error:Warning 1 Cannot find wrapper assembly for type library "Excel".


http://img251.imageshack.us/img251/9435/excelga9.jpg

I have tried deleting and readding (Several Times) even copying the files from a working project into the debug folder without any luck.

Any ideas how to fix this?

Thanks
toe

Are you working on the same project files both at home and at work?
What version of Office do you have installed at each location?

I got it to work by also adding the 5.0 object library.

Even though when i added the 11.0 object library it added the Excel Ref with the yellow icon but came up with the error icon

At home it 2002 and work 2003.
They are differnet projects

You shouldnt have to add the 5.0 version. That sounds bad for deployment.

Create a new test project and add a ref to 11 and see if it works ok. If it does then try removing your reference and readding it in your problematic project.

Going to try a office update first, but the IT guy is having problems getting the network to allow it to update.

Sounds like a firewall issue.

I think it may be alright except the fact that the Reference with the red arrow is not pointing to the Debug folder as in my other project which is now causing a Member Not Found Error?

http://img254.imageshack.us/img254/6654/pointde0.jpg

Should i and how can i change it to point to the debug folder

It shouldnt be point to your local project folder. It should be pointing to the Global Assembly Cache (GAC).

Try removing the references and rebuilding your project. then readd the references and see if it fixes the ref issue.

Removed, rebuilt and re added the Microsoft Excel 11.0 Object Library and it

puts a yellow error icon on the Excel Reference as per the previous screen shot.

When i rebuild again it produces these errors:

Warning 1 The referenced component 'Excel' could not be found.

Warning 2 Cannot find wrapper assembly for type library "Excel".

Did you try adding the reference on a new blank project yet like I mentioned in #5?

Just did it then and its the same result :(

Can the office updates be downloaded and saved to a usb or disk?

No, but service packs can but its best to do the office update from the system with office on it,

Ok, all fixed after i installed service pack 3 :)

Thanks for your help

I'm having the same problem. I've tried all the potential fixes above, but to no avail. I have SP3 installed already.

EDIT: Nevermind. I was getting a second error in addition to Excel. VBIDE. I removed both and then re-added Excel and it worked.