Unable to open excel macro from Control-M

I’ve been trying to get several Control-M jobs to work on our new Win 2008 R2 x64 Servers, but they always fail as they are trying to open scripts that call Excel macros as part of their function.

2012-08-14 17 : 24: 59 Error generating Sample Report [SampleRptBatch][CreateFileNames] Microsoft Office Excel cannot access the file ‘D:\SampleReport\SampleFormat.xlsm’. There are several possible reasons:

• The file name or path does not exist.

• The file is being used by another program.

• The workbook you are trying to save has the same name as a currently open workbook.

On analysis, I can see that the Control-M Agent (ver 7) is running jobs as a Service, and not as a TCP or RDP session as I had thought.

This all comes down to an issue with Services, Win 2008 R2 x64 and Excel 2007. For Excel to open, when called from a service, it requires a “Desktop” folder to be placed in

    C:\Windows\SysWOW64\config\systemprofile\Desktop

Qgawa’s reply here, helped me sort this out.

http://social.msdn.microsoft.com/Forums/en/innovateonoffice/thread/b81a3c4e-62db-488b-af06-44421818ef91