When executing an Office Excel Macro from VisualCron (V7) it fails as per below. The option is turned on in Microsoft Excel to trust all macros and the macro runs just fine if I execute it manually from Excel so am I missing a setting or security option that I need for it to run from VisualCron?

The items it suggested to check are not an issue:
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.


Error Message:
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Runtime.InteropServices.COMException: Microsoft Office Excel cannot access the file 'D:\Program Files\Decisions Made Easy\Cipher\Reports\BarillaISF\Templates\Rename.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.
--- End of inner exception stack trace ---
at System.RuntimeType.InvokeDispMethod(String name, BindingFlags invokeAttr, Object target, Object[] args, Boolean[] byrefModifiers, Int32 culture, String[] namedParameters)
at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
at Bt80xSkfTWudfYX562.Q0LP2VANLNgalVLDYo.o2yCXNsP6()
Exception in Task: Non zero exit code
Exception in Task: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Runtime.InteropServices.COMException: Microsoft Office Excel cannot access the file 'D:\Program Files\Decisions Made Easy\Cipher\Reports\BarillaISF\Templates\Rename.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.
--- End of inner exception stack trace ---
at System.RuntimeType.InvokeDispMethod(String name, BindingFlags invokeAttr, Object target, Object[] args, Boolean[] byrefModifiers, Int32 culture, String[] namedParameters)
at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
at Bt80xSkfTWudfYX562.Q0LP2VANLNgalVLDYo.o2yCXNsP6()
Exception in Task: Non zero exit code

Could you move or copy to other folder, like temp folder, to see if it is a permissions problem of that particular folder.

Alternatively you could try to run the Task as another user (Credential).

---

I'll see if sharing the folder will remedy the issue; however one of the other users who does most of our Office Macro type tasks is saying I also need to do this:

1. Login to this path if the OS is 64 bit
C:\Windows\SysWOW64\config\systemprofile

2. Create a folder Desktop there and grant full permission to that; then retry the VC task

If the OS is 32 bit here is the path to config the folder
C:\WINDOWS\system32\config\systemprofile

I'll see if sharing the folder will remedy the issue; however one of the other users who does most of our Office Macro type tasks is saying I also need to do this:

1. Login to this path if the OS is 64 bit
C:\Windows\SysWOW64\config\systemprofile

2. Create a folder Desktop there and grant full permission to that; then retry the VC task

If the OS is 32 bit here is the path to config the folder
C:\WINDOWS\system32\config\systemprofile

Ok, it might be something specific to your script because I have not heard of that need before.

---

Please test this version, we have added more debugging to it:

http://www.visualcron.co....aspx?g=posts&t=3805 

---