Excel sheet stopped working - VisualCron

NicholasDawson
Paid support Topic Starter

2020-01-16T14:07:04Z

Help!

32-bit Excel, 64-bit Windows server.
Other Excel macro jobs are working fine.
Error is indicating it doesn't think Excel is installed.
If we log on to the server as the VC service user the spreadsheet runs fine.
We've "repaired" Office on the server
Tried running as a domain admin
Tried rolling back to a version we knew was working.

Info Log:

32-bit Excel, 64-bit Windows server.
Other Excel macro jobs are working fine.
Error is indicating it doesn't think Excel is installed.
If we log on to the server as the VC service user the spreadsheet runs fine.
We've "repaired" Office on the server
Tried running as a domain admin

Info Log:
14:00:19: Is 64 bit process: False
14:00:19: Is 64 bit operating system: True
14:00:19: Current user: NT AUTHORITY\SYSTEM
14:00:19: .NET version: 4.0.30319.42000
14:00:19: AddExceptionHandlers
14:00:19: AddAssemblyLoadEvent
14:00:19: Argument(0): 1032595
14:00:19: CreateTaskServiceChannel
14:00:19: CreateTaskServiceChannel->Complete
14:00:19: pts.CreateService(UniqueAddressId)
14:00:19: pts.CreateService(UniqueAddressId)->Complete
14:00:19: Server->Execute path: C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe
14:00:19: Server->Executing Task process
14:00:19: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->CreateService->Response channel created on address: /TaskProcess/1032595
14:00:19: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Requesting Task information
14:00:19: Server->Sending Task information
14:00:19: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Task information sent
14:00:19: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Task information received
14:00:19: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Assembly loaded: System.Transactions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
14:00:19: Server->Task information sent
14:00:19: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Before execute
14:00:19: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->RunMacro->OfficeApplicationType: Excel
14:00:19: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->RunMacro->Parameter count: 0
14:00:19: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->RunMacro->File: \\<servername>\shared\IT\Xmon\RiskBBGData\Automated\Data_Saver_AUTOMATED.xlsm exists.
14:00:19: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->RunExcelMacro->Enter
14:00:19: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Assembly loaded: Microsoft.Office.Interop.Excel, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c
14:00:19: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Assembly loaded: office, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c
14:00:27: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->RunExcelMacro->Excel.Application.Version: 16.0
14:00:27: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->SetTrustedLocation->Looping through sub key names, searching for path: \\<servername>\shared\IT\Xmon\RiskBBGData\Automated
14:00:27: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Trusted location: C:\Program Files (x86)\Microsoft Office\Root\Office16\XLSTART\
14:00:27: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Trusted location: C:\Windows\system32\config\systemprofile\AppData\Roaming\Microsoft\Excel\XLSTART
14:00:27: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Trusted location: C:\Windows\system32\config\systemprofile\AppData\Roaming\Microsoft\Templates
14:00:27: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Trusted location: C:\Program Files (x86)\Microsoft Office\Root\Templates\
14:00:27: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Trusted location: C:\Program Files (x86)\Microsoft Office\Root\Office16\STARTUP\
14:00:27: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Trusted location: C:\Program Files (x86)\Microsoft Office\Root\Office16\Library\
14:00:27: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Trusted location: \\<servername>\shared\it\opsit\apps\MS FX Trade Parser
14:00:27: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Trusted location: \\<servername>\shared\IT\Xmon\RiskBBGData
14:00:27: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Trusted location: \\<servername>\shared\it\opsit\apps\GS FX Trade Parser
14:00:27: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Trusted location: \\<servername>\shared\it\opsit\apps\gs exposures
14:00:27: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Trusted location: \\<servername>\shared\IT\Xmon
14:00:27: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Trusted location: \\<servername>\shared\it\opsit
14:00:27: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Trusted location: \\<servername>\shared\it\opsit\apps\Citi Collateral Saver
14:00:27: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Trusted location: \\<servername>\shared
14:00:27: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Trusted location: \\<servername>\shared\it\opsit\apps\Citi FX Trade Parser
14:00:27: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Trusted location: \\<servername>\shared\CRITICAL\Risk\RISK\1. DATABASE\1. Calculation\DD
14:00:27: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Trusted location: D:\Software
14:00:27: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Trusted location: \\<servername>\shared\IT\Xmon\RiskBBGData\Automated
14:00:27: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->SetTrustedLocation->Found existing security setting for this path
14:00:27: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->CheckSetMacroEnabled->VBAWarnings is correctly disabled
14:00:27: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->RunExcelMacro->Open object
14:00:32: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->RunExcelMacro->Running macro: VCRON_START_MACRO
14:00:32: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->RunExcelMacro->Closing workbook
14:00:32: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->RunExcelMacro->Releasing ComObject (WorkBook)
14:00:32: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->RunExcelMacro->Releasing ComObject (WorkBooks)
14:00:32: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->RunExcelMacro->Quit
14:00:32: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->RunExcelMacro->Releasing ComObject (oExcel)
14:00:32: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Preparing Task log
14:00:32: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Sending result - success: False
14:00:32: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Result sent
14:00:33: Server->Executing Task process exited with exit code: 0
14:00:33: Server->Waiting for completion and result
14:00:33: Server->Task result received, success: False

Error:
Exception in Task: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032582)->RunExcelMacro->COMException System.Runtime.InteropServices.COMException (0x800AC472): Exception from HRESULT: 0x800AC472
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 TaskOfficeMacro.OfficeMacro.mvlsadi6x() - maybe Microsoft Office is not installed? This Task requires Microsoft Office being installed.
ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032582)->RunExcelMacro->Error closing workbook: System.Runtime.InteropServices.COMException (0x800AC472): Exception from HRESULT: 0x800AC472
at Microsoft.Office.Interop.Excel._Workbook.set_Saved(Boolean RHS)
at TaskOfficeMacro.OfficeMacro.mvlsadi6x()
ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032582)->RunExcelMacro->Error when performing Quit: System.Runtime.InteropServices.COMException (0x800AC472): Exception from HRESULT: 0x800AC472
at Microsoft.Office.Interop.Excel.ApplicationClass.Quit()
at TaskOfficeMacro.OfficeMacro.xdNHwJPT4sgWyXm8Cat(Object )
at TaskOfficeMacro.OfficeMacro.mvlsadi6x()
ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032582)->Unhandled execution error: System.Runtime.InteropServices.COMException (0x800AC472): Exception from HRESULT: 0x800AC472
at TaskOfficeMacro.OfficeMacro.mvlsadi6x()
at TaskOfficeMacro.OfficeMacro.jm5UPNp03()
at SQLxjoppGsWdA60GuL.KgA7bGSOEiUeZb7saw.klO2JF2WC(String[] )

Error:
Exception in Task: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032582)->RunExcelMacro->COMException System.Runtime.InteropServices.COMException (0x800AC472): Exception from HRESULT: 0x800AC472
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 TaskOfficeMacro.OfficeMacro.mvlsadi6x() - maybe Microsoft Office is not installed? This Task requires Microsoft Office being installed.
ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032582)->RunExcelMacro->Error closing workbook: System.Runtime.InteropServices.COMException (0x800AC472): Exception from HRESULT: 0x800AC472
at Microsoft.Office.Interop.Excel._Workbook.set_Saved(Boolean RHS)
at TaskOfficeMacro.OfficeMacro.mvlsadi6x()
ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032582)->RunExcelMacro->Error when performing Quit: System.Runtime.InteropServices.COMException (0x800AC472): Exception from HRESULT: 0x800AC472
at Microsoft.Office.Interop.Excel.ApplicationClass.Quit()
at TaskOfficeMacro.OfficeMacro.xdNHwJPT4sgWyXm8Cat(Object )
at TaskOfficeMacro.OfficeMacro.mvlsadi6x()
ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032582)->Unhandled execution error: System.Runtime.InteropServices.COMException (0x800AC472): Exception from HRESULT: 0x800AC472
at TaskOfficeMacro.OfficeMacro.mvlsadi6x()
at TaskOfficeMacro.OfficeMacro.jm5UPNp03()
at SQLxjoppGsWdA60GuL.KgA7bGSOEiUeZb7saw.klO2JF2WC(String[] )

Support
Official support

2020-01-20T09:23:40Z

#2

Originally Posted by: NicholasDawson

Help!

32-bit Excel, 64-bit Windows server.
Other Excel macro jobs are working fine.
Error is indicating it doesn't think Excel is installed.
If we log on to the server as the VC service user the spreadsheet runs fine.
We've "repaired" Office on the server
Tried running as a domain admin
Tried rolling back to a version we knew was working.

Info Log:

32-bit Excel, 64-bit Windows server.
Other Excel macro jobs are working fine.
Error is indicating it doesn't think Excel is installed.
If we log on to the server as the VC service user the spreadsheet runs fine.
We've "repaired" Office on the server
Tried running as a domain admin

Info Log:
14:00:19: Is 64 bit process: False
14:00:19: Is 64 bit operating system: True
14:00:19: Current user: NT AUTHORITY\SYSTEM
14:00:19: .NET version: 4.0.30319.42000
14:00:19: AddExceptionHandlers
14:00:19: AddAssemblyLoadEvent
14:00:19: Argument(0): 1032595
14:00:19: CreateTaskServiceChannel
14:00:19: CreateTaskServiceChannel->Complete
14:00:19: pts.CreateService(UniqueAddressId)
14:00:19: pts.CreateService(UniqueAddressId)->Complete
14:00:19: Server->Execute path: C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe
14:00:19: Server->Executing Task process
14:00:19: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->CreateService->Response channel created on address: /TaskProcess/1032595
14:00:19: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Requesting Task information
14:00:19: Server->Sending Task information
14:00:19: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Task information sent
14:00:19: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Task information received
14:00:19: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Assembly loaded: System.Transactions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
14:00:19: Server->Task information sent
14:00:19: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Before execute
14:00:19: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->RunMacro->OfficeApplicationType: Excel
14:00:19: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->RunMacro->Parameter count: 0
14:00:19: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->RunMacro->File: \\<servername>\shared\IT\Xmon\RiskBBGData\Automated\Data_Saver_AUTOMATED.xlsm exists.
14:00:19: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->RunExcelMacro->Enter
14:00:19: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Assembly loaded: Microsoft.Office.Interop.Excel, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c
14:00:19: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Assembly loaded: office, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c
14:00:27: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->RunExcelMacro->Excel.Application.Version: 16.0
14:00:27: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->SetTrustedLocation->Looping through sub key names, searching for path: \\<servername>\shared\IT\Xmon\RiskBBGData\Automated
14:00:27: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Trusted location: C:\Program Files (x86)\Microsoft Office\Root\Office16\XLSTART\
14:00:27: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Trusted location: C:\Windows\system32\config\systemprofile\AppData\Roaming\Microsoft\Excel\XLSTART
14:00:27: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Trusted location: C:\Windows\system32\config\systemprofile\AppData\Roaming\Microsoft\Templates
14:00:27: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Trusted location: C:\Program Files (x86)\Microsoft Office\Root\Templates\
14:00:27: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Trusted location: C:\Program Files (x86)\Microsoft Office\Root\Office16\STARTUP\
14:00:27: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Trusted location: C:\Program Files (x86)\Microsoft Office\Root\Office16\Library\
14:00:27: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Trusted location: \\<servername>\shared\it\opsit\apps\MS FX Trade Parser
14:00:27: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Trusted location: \\<servername>\shared\IT\Xmon\RiskBBGData
14:00:27: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Trusted location: \\<servername>\shared\it\opsit\apps\GS FX Trade Parser
14:00:27: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Trusted location: \\<servername>\shared\it\opsit\apps\gs exposures
14:00:27: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Trusted location: \\<servername>\shared\IT\Xmon
14:00:27: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Trusted location: \\<servername>\shared\it\opsit
14:00:27: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Trusted location: \\<servername>\shared\it\opsit\apps\Citi Collateral Saver
14:00:27: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Trusted location: \\<servername>\shared
14:00:27: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Trusted location: \\<servername>\shared\it\opsit\apps\Citi FX Trade Parser
14:00:27: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Trusted location: \\<servername>\shared\CRITICAL\Risk\RISK\1. DATABASE\1. Calculation\DD
14:00:27: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Trusted location: D:\Software
14:00:27: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Trusted location: \\<servername>\shared\IT\Xmon\RiskBBGData\Automated
14:00:27: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->SetTrustedLocation->Found existing security setting for this path
14:00:27: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->CheckSetMacroEnabled->VBAWarnings is correctly disabled
14:00:27: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->RunExcelMacro->Open object
14:00:32: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->RunExcelMacro->Running macro: VCRON_START_MACRO
14:00:32: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->RunExcelMacro->Closing workbook
14:00:32: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->RunExcelMacro->Releasing ComObject (WorkBook)
14:00:32: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->RunExcelMacro->Releasing ComObject (WorkBooks)
14:00:32: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->RunExcelMacro->Quit
14:00:32: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->RunExcelMacro->Releasing ComObject (oExcel)
14:00:32: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Preparing Task log
14:00:32: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Sending result - success: False
14:00:32: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032595)->Result sent
14:00:33: Server->Executing Task process exited with exit code: 0
14:00:33: Server->Waiting for completion and result
14:00:33: Server->Task result received, success: False

Error:
Exception in Task: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032582)->RunExcelMacro->COMException System.Runtime.InteropServices.COMException (0x800AC472): Exception from HRESULT: 0x800AC472
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 TaskOfficeMacro.OfficeMacro.mvlsadi6x() - maybe Microsoft Office is not installed? This Task requires Microsoft Office being installed.
ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032582)->RunExcelMacro->Error closing workbook: System.Runtime.InteropServices.COMException (0x800AC472): Exception from HRESULT: 0x800AC472
at Microsoft.Office.Interop.Excel._Workbook.set_Saved(Boolean RHS)
at TaskOfficeMacro.OfficeMacro.mvlsadi6x()
ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032582)->RunExcelMacro->Error when performing Quit: System.Runtime.InteropServices.COMException (0x800AC472): Exception from HRESULT: 0x800AC472
at Microsoft.Office.Interop.Excel.ApplicationClass.Quit()
at TaskOfficeMacro.OfficeMacro.xdNHwJPT4sgWyXm8Cat(Object )
at TaskOfficeMacro.OfficeMacro.mvlsadi6x()
ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032582)->Unhandled execution error: System.Runtime.InteropServices.COMException (0x800AC472): Exception from HRESULT: 0x800AC472
at TaskOfficeMacro.OfficeMacro.mvlsadi6x()
at TaskOfficeMacro.OfficeMacro.jm5UPNp03()
at SQLxjoppGsWdA60GuL.KgA7bGSOEiUeZb7saw.klO2JF2WC(String[] )

Error:
Exception in Task: ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032582)->RunExcelMacro->COMException System.Runtime.InteropServices.COMException (0x800AC472): Exception from HRESULT: 0x800AC472
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 TaskOfficeMacro.OfficeMacro.mvlsadi6x() - maybe Microsoft Office is not installed? This Task requires Microsoft Office being installed.
ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032582)->RunExcelMacro->Error closing workbook: System.Runtime.InteropServices.COMException (0x800AC472): Exception from HRESULT: 0x800AC472
at Microsoft.Office.Interop.Excel._Workbook.set_Saved(Boolean RHS)
at TaskOfficeMacro.OfficeMacro.mvlsadi6x()
ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032582)->RunExcelMacro->Error when performing Quit: System.Runtime.InteropServices.COMException (0x800AC472): Exception from HRESULT: 0x800AC472
at Microsoft.Office.Interop.Excel.ApplicationClass.Quit()
at TaskOfficeMacro.OfficeMacro.xdNHwJPT4sgWyXm8Cat(Object )
at TaskOfficeMacro.OfficeMacro.mvlsadi6x()
ExecuteProcess("C:\Program Files (x86)\VisualCron\TaskOfficeMacrox86.exe" 1032582)->Unhandled execution error: System.Runtime.InteropServices.COMException (0x800AC472): Exception from HRESULT: 0x800AC472
at TaskOfficeMacro.OfficeMacro.mvlsadi6x()
at TaskOfficeMacro.OfficeMacro.jm5UPNp03()
at SQLxjoppGsWdA60GuL.KgA7bGSOEiUeZb7saw.klO2JF2WC(String[] )

So, other macros are working?
And if you perform a simple test macro from https://www.visualcron.c...fice_-_office_macro.html (WriteFile.zip), does that macro work?

In that case, delete the whole problematic macro task and re-create it. If that doesn't work, you will have to break down the script line by line, to see where the problem is, regardless if it has been working before or not.

Michael
Support
http://www.visualcron.com

Please like VisualCron on facebook!

NicholasDawson
Paid support Topic Starter

2020-01-21T11:15:26Z

#3

Correct - other tasks work fine.
Also, what is odd is if we create a new task and don't turn on "Execute in 32-bit Mode" then the output debug says "Is 64-bit process : False"
Surely that's incorrect?

Support
Official support

2020-01-21T12:30:54Z

#4

Originally Posted by: NicholasDawson

Correct - other tasks work fine.
Also, what is odd is if we create a new task and don't turn on "Execute in 32-bit Mode" then the output debug says "Is 64-bit process : False"
Surely that's incorrect?

Yes but most likely not related to your issue,
you should break down the code line by line and see which line is causing the problem on that task

Michael
Support
http://www.visualcron.com

Please like VisualCron on facebook!

Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.

Login