Interop.Excel version 11 does not work with Office 2003 sp2

[Hua Huang]

Hi,

We just upgraded to MS office 2003 sp2. We used the Interop.Excel version
11.xxxx in VS.net 2003 to generate the excel spreadsheet. It no longer works
in sp2 environment. We've got "Rejected Safe Mode action : Microsoft Office
Excel." exception and then "Faulting application excel.exe, version
11.0.6560.0, stamp 4296b6f2, faulting module mso.dll, version 11.0.6568.0,
stamp 42e18ef6, debug? 0, fault address 0x0003446c." exception.

Thanks for your help in advance!
Hua

 

[Clegg]

I am having a similar problem where I cannot use the Interop.Excel calls
after SP2, did you ever find a solution?

 

[Stephane Rodriguez]

I remember have seen a post in MSDN blogs about that a week or two
Anyway, if Interop.Excel.dll is produced by you when adding a referenc
to Excel.exe then I would strongly suggest to use the official Offic
2003 assemblies instead, Office 2003 primary interop assemblies. Thos
are signed, unlike those generated from VisualStudio, and thanks t
this can mitigate the XP SP2 problems

 

[Hua Huang]

Yes.
Go to Component Services (Control Panel->Admin tool), expand My Computer,
then expand "DCOM Config", find "Microsoft.Excel.Application", right click to
show "Property", then select "Identity" tab. It says Which user account do
you want to use to run this application?, choose "This User", then enters an
account which has "Administrator" role. Excel application need to run under
the admin account from my web application.

Good luck!
Hua