Automating Office Applications on the Server Side

If the aim of the automation is to use a predefined template, then it is not a good idea.
Read article from microsoft:
http://support.microsoft.com/kb/257757/en-us

Hence, ASP.NET code used on the server side sometimes fails to execute due to internal “Interop” reasons.
Also, important to note that during debugging code works OK.
The problem arises only when website is published on the IIS.
Same occurs for both Vista and Windows Server 2003.

The workaround is to call EXE windows forms application from ASP.NET code and then use the file generated by EXE.

Leave a comment