Hi I am trying to run a simple macro created in desktop. however this is the error when trying to run the task. Was able to run manually - trust center settings is allow all macros to run
ExecuteProcess("C:\Program Files (x86)\VisualCron\\TaskOfficeMacrox86.exe" 25)->RunExcelMacro->COMException System.Runtime.InteropServices.COMException (0x800A03EC): Microsoft Excel cannot access the file 'C:\Users\pavi\Desktop\Book1.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.
at Microsoft.Office.Interop.Excel.Workbooks.Open(String Filename, Object UpdateLinks, Object ReadOnly, Object Format, Object Password, Object WriteResPassword, Object IgnoreReadOnlyRecommended, Object Origin, Object Delimiter, Object Editable, Object Notify, Object Converter, Object AddToMru, Object Local, Object CorruptLoad)
at TaskOfficeMacro.OfficeMacro.AVqlAmEsM() - maybe Microsoft Office is not installed? This Task requires Microsoft Office being installed.
ExecuteProcess("C:\Program Files (x86)\VisualCron\\TaskOfficeMacrox86.exe" 25)->Unhandled execution error: System.Runtime.InteropServices.COMException (0x800A03EC): Microsoft Excel cannot access the file 'C:\Users\pavi\Desktop\Book1.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.
at TaskOfficeMacro.OfficeMacro.AVqlAmEsM()
at TaskOfficeMacro.OfficeMacro.utG9IpawD()
at FTEBkwMfx7MseSFqYZ.Yvs4PJRTMKfPO7TXE4.J7eDNHM8S(String[] )
Exception in Task: ExecuteProcess("C:\Program Files (x86)\VisualCron\\TaskOfficeMacrox86.exe" 25)->RunExcelMacro->COMException System.Runtime.InteropServices.COMException (0x800A03EC): Microsoft Excel cannot access the file 'C:\Users\pavi\Desktop\Book1.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 workboo