Excel Interop FYI

[MTSkull]

I just ran into this problem and thought you guys should know.

 

I came into work yesterday morning and my computer said it had installed a critical update and had to restart. This happens every now and again so I paid it no mind.

 

I opened my project that uses Microsoft.Office.Interop.Excel made some changes then Attempted to compile, which generated an error "Can't find Microsoft.Office.Interop.Excel". The project worked great and compiled the night before.

 

I have spent about 2 days trying to locate the fix.

 

One site said I can use Interop.Excel which I can see in the Object Browser but could not figure out how to connect to.

 

I fixed the problem by tracing though this thread which pointed me to this download for the Office 2003 Primary Interop assemblies. After I registered the dll's i had to make a minor code modification to get up and running again.

 

I was curious if any one else saw this, especially since the project worked the night before an update and did not the morning after.

 

Cheers

MTS

[Nate Bross]

What update/hotfix was installed? Is there a KB article associated with it?

[MTSkull]

Good question, I had not thought to investigate. I was too busy fixing it (with my boss breathing down my neck).

 

My computer automatically downloaded the following the morning of 10/15/2008

 

Windows XP Security Updates: KB956803, KB956391, KB957095, KB956390, KB954211, KB956841

 

Office 2007: KB955936

 

Office 2003: KB955466, KB957257

 

My guess is the Office 2007 might have killed it since it...

Security Update for 2007 Microsoft Office System (KB955936)

A security vulnerability exists in the 2007 Microsoft Office system and the Microsoft Office Compatibility Pack that could allow arbitrary code to run when a maliciously modified file is opened. This update resolves that vulnerability.

 

I am not really sure though.

MTS