Issue with adding Excel COM reference in VS 2005 using Office 2003
Posted on 2011-02-16
I have an application that was created using office 2003 and the Microsoft.Office.Interop.Excel.dll. Everything has worked great for a year or so with the portion of the app that writes to Excel. My pc was recently upgraded to Office 2010...so I had to remove the old and add the new references for Excel...again...no issues. The problem was though, the app runs from Citrix, and since it has Office 2003, I needed to change them back...fine...no worries right?
Well, I made the changes on a pc with Office 2003, ran the app locally...everything worked. Placed the app on the server and the Excel portion blows up. It appears that when I added the Office 2K3 reference back in, it is now using Interop.Excel.dll...a different dll then what it was using before.
Now, I can just replace that other dll with the one it is currently using, but I want to know why it is using Interop.Excel.dll as opposed to Microsoft.Office.Interop.Excel. I have tried this on a few pc's with Office 2K3 and I get the same result.