Issue opening MS Word document on Windows Server 2008 through Scheduled Task

Hi,

The below coding runs when an Excel file is opened. It's being done on a virtual machine on Windows Server 2008 with Office 2007 installed.

Please Login or Register  to view this content.

This coding errors out on the Open command with an error stating "Object Required" when this Excel file is opened through a Scheduled Task. If I open the Excel file directly, the coding works.

Any ideas on what the "Object Required" might be alluding to? The objWord doesn't error out on the line above where it sets a property, and through Task Manager I can see that the WinWord process has been started.

I've exhausted my knowledge, so if you have ANY ideas, please share them.

I've found that I can get past this line erroring if I replace this:

Please Login or Register  to view this content.

With this:

Please Login or Register  to view this content.

It appears the document is failing to open though. If I add after this code a loop through objWord.Documents, I do not find any open documents. I've moved the document from a server folder to the C Drive without any luck. The fullFileName is the correct path.

I found a working solution.

On, Windows 2008 Server x64 create this folder.
C:\Windows\SysWOW64\config\systemprofile\Desktop

http://social.msdn.microsoft.com/For...6-44421818ef91