Unable to execute macro through VC task - VisualCron - Forum

Community forum

krishnat
2014-01-07T13:46:35Z
Hi,

When I tried executing a macro file through VC task I am getting the following error

"System.Runtime.InteropServices.COMException (0x800A9C68): Exception from HRESULT: 0x800A9C68
at Microsoft.Office.Interop.Excel.ApplicationClass.Run(Object Macro, Object Arg1, Object Arg2, Object Arg3, Object Arg4, Object Arg5, Object Arg6, Object Arg7, Object Arg8, Object Arg9, Object Arg10, Object Arg11, Object Arg12, Object Arg13, Object Arg14, Object Arg15, Object Arg16, Object Arg17, Object Arg18, Object Arg19, Object Arg20, Object Arg21, Object Arg22, Object Arg23, Object Arg24, Object Arg25, Object Arg26, Object Arg27, Object Arg28, Object Arg29, Object Arg30)
at aRZtPY34eiTpFZPJcg.amclYtsKJUEE7kUZ5t.R5RZ00Tkg() - maybe Microsoft Office is not installed? This Task requires Microsoft Office being installed.
Exception in Task: Non zero exit code
Exception in Task: System.Runtime.InteropServices.COMException (0x800A9C68): Exception from HRESULT: 0x800A9C68
at Microsoft.Office.Interop.Excel.ApplicationClass.Run(Object Macro, Object Arg1, Object Arg2, Object Arg3, Object Arg4, Object Arg5, Object Arg6, Object Arg7, Object Arg8, Object Arg9, Object Arg10, Object Arg11, Object Arg12, Object Arg13, Object Arg14, Object Arg15, Object Arg16, Object Arg17, Object Arg18, Object Arg19, Object Arg20, Object Arg21, Object Arg22, Object Arg23, Object Arg24, Object Arg25, Object Arg26, Object Arg27, Object Arg28, Object Arg29, Object Arg30)
at aRZtPY34eiTpFZPJcg.amclYtsKJUEE7kUZ5t.R5RZ00Tkg() - maybe Microsoft Office is not installed? This Task requires Microsoft Office being installed.
Exception in Task: Non zero exit code
"

I have created desktop folders at SYS64WOW & System32 location, also granted full access. Still the issue persist.

This macro will copy certain data from xlsm file & paste that to PPT template, then it will perform some formatting part, in addition this macro will open a ppt file and copy couple of slides and paste it in the destination ppt file.

Please advice.

Thanks in advance,
Krishna
Support
2014-01-07T13:50:58Z
Have you installed Office at the VisualCron server, if yes, which version, x64 or x86?
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
krishnat
2014-01-07T14:09:14Z
Yes, it is there and also I am able to run the respective macro manually.
krishnat
2014-01-07T14:27:51Z
The version I am using is MS office 2010 Version - 14.04760.1000(32-bit)

VisualCron version 7.0.6

Also I have selected the check box to enable for 32 bit (Execute in 32bit mode) at VC task

Axel F
2014-01-13T10:00:04Z
Hi ,

you are using an Excel File including macros (.xlsm)

Try this

Open Excel and mark in Trust Center Options the Option : Activate all Macros.

I had the same Error on Access .

For me it works .

regards
Scroll to Top