I recently transferred some scripts running on a virtual Windows XP machine to a virtual Windows 7 box, running Office 2010. My scripts ran daily from Task Scheduler and some opened up an Excel spreadsheet to get data. I found that running the scripts manually worked, but running with the Task Scheduler did not open Excel properly to access the data. Microsoft say they do not support the unattended automation of Office.
http://support.microsoft.com/kb/257757
The solution to get office to work via the Task Scheduler is to create a folder called Desktop in the location C:\Windows\System32\config\systemprofile
I hope this helps others with the same problem.
On another note, the ReadCSV UDF does not work if the delimiter is used inside quotes in the data.
Cheers,
_________________________
Bill
