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 "Cant 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 dlls 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