To Solve Excel 2007 automation problem on top of a Windows Server 2008, a Desktop folder is necessary in the systemprofile folder to open file by Excel. It disappears from Windows Server 2008, however Windows Server 2003 had the folder.
If this folder misses it may cause System Errors like:
- Microsoft Office Excel cannot access the file "filename"
- Unable to setup Excel
Solution is to create 'Desktop' folder under following paths on your machine:
If your machine is 64-bit then,
C:\Windows\SysWOW64\config\systemprofile\
If your machine is 32-bit then,
C:\Windows\System32\config\systemprofile\