Answer found ....... !!!!!!!
Officially, Microsoft Office 2003 Interop is not supported by Microsoft Windows on the 2008 server.
But after many permutations and combinations with code and search, we came across one solution that works for our scenario.
The solution is to plug in the difference between how Windows 2003 and 2008 maintains its folder structure, since Office Interop depends on the desktop folder to open the file / save. In the 2003 system, there is a desktop folder under the system profile, missing in 2008.
So, when we create this folder in 2008 under the corresponding hierarchy, as indicated below; Interop office can save the file as needed. This desktop folder must be created under
C: \ Windows \ System32 \ Config \ systemprofile
and
C: \ Windows \ SysWOW64 \ Config \ systemprofile
It worked for me ...
Thanks guys..!
source share