Hi Ashok,
The application architecture you are employing is not recommended and supported by Microsoft. MS Office has never been designed or tested for this kind of usage.
Please refer to the following knowledge Base article:
257757 INFO: Considerations for Server-Side Automation of Office
http://support.microsoft.com/?id=257757
You are attempting to utilize automation of Microsoft Office in an unattended, non-interactive solution. There are many known complications associated that I want you to be fully aware of before you continue your development project. Microsoft Office was
not designed to accommodate server side automation and, therefore, it is untested and unsupported. In addition, Office cannot be changed to run effectively as a server-side component and stay compatible to its design as an end-user application. We cannot offer
software updates, patches or production code to support or provide a solution for your issue.
You may seek to mitigate the effects of certain problems through your own code or server configuration, but you will need to fully test and deploy it at your own risk as you would any custom solution. We highly suggest you review the design of your project
and implement one of the known alternatives.
Should you choose to continue with a server side solution, we want you to be aware of the known problems including but not limited to:
•Security issues
•Reentrancy and scalability
•Stability
•Upgrade issues
•Licensing implications
As a workaround, I recommend using Office Open XML formats to generate Office documents. The Open XML file formats are a public standard.
Microsoft provides an SDK for manipulating Open XML file formats from the .NET 3.x Framework. For more information about the SDK and about how to use the SDK to create or edit Open XML files, visit the following Microsoft Developer Network (MSDN) Web sites:
Open XML SDK Documentation
http://msdn.microsoft.com/en-us/library/bb226703.aspx
How to: Manipulate Office Open XML Formats Documents
http://msdn.microsoft.com/en-us/library/aa982683.aspx
Manipulating Word 2007 Files with the Open XML Object Model (Part 1 of 3)
http://msdn.microsoft.com/en-us/library/bb656295.aspx
Manipulating Word 2007 Files with the Open XML Object Model (Part 2 of 3)
http://msdn.microsoft.com/en-us/library/bb739835.aspx
Manipulating Word 2007 Files with the Open XML Object Model (Part 3 of 3)
http://msdn.microsoft.com/en-us/library/bb727374.aspx
Manipulating Excel 2007 and PowerPoint 2007 Files with the Open XML Object Model (Part 1 of 2)
http://msdn.microsoft.com/en-us/library/bb739834.aspx
Manipulating Excel 2007 and PowerPoint 2007 Files with the Open XML Object Model (Part 2 of 2)
http://msdn.microsoft.com/en-us/library/bb727373.aspx
Building Server-Side Document Generation Solutions Using the Open XML Object Model (Part 1 of 2)
http://msdn2.microsoft.com/en-us/library/bb735940.aspx
Building Server-Side Document Generation Solutions Using the Open XML Object Model (Part 2 of 2)
http://msdn2.microsoft.com/en-us/library/bb735939.aspx
Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
