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

[Guest]

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

 

[Guest]

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

 

[Guest]

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