Hi all

I'm trying to write data to Excel from my ASP.NET application and I'm having
trouble with the first hurdle. I have added a reference to the
Microsoft.Office.Interop.Excel dll which is in the application's Bin folder.

Every time I try to use the application I get the following error:

...........................

Retrieving the COM class factory for component with CLSID
{00020819-0000-0000-C000-000000000046} failed due to the following error:
80040154.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.

Exception Details: System.Runtime.InteropServices.COMException: Retrieving
the COM class factory for component with CLSID
{00020819-0000-0000-C000-000000000046} failed due to the following error:
80040154.

..........................

I have tried numerous investigations. I have used the Dependency Walker
application and have established there are no missing dependent dlls. I have
completely replaced the dll with another copy which works on another machine,
but still get the same error. I have tried to register the dll using regsvr32
but get this error message:

........................

P:\C057SMP\cms\bin\Microsoft.Office.Interop.Excel. dll was loaded, but the
DllRegisterServer entry point was not found.

The file can not be registered.

......................

I've completely run out of ideas and I need to get this Excel export working.

I have a lot of experience of Excel's API and have done this sort of thing
numerous times before in different roles, but have never encountered this
problem.

Has anyone got any suggestions?

Thanks

David