Excel Macro Error - VisualCron - Forum

Community forum

Erica
  •  Erica
  • Paid support Topic Starter
2014-07-18T20:19:07Z
Hey All,
I been trying to run an Excel Maro task but I get the following error.
ExecuteProcess("C:\Program Files\VisualCron\\TaskOfficeMacrox86.exe" 257)->RunExcelMacro->COMException System.Runtime.InteropServices.COMException (0x800A03EC): Microsoft Excel cannot access the file 'C:\Freedom\CombineSheets.xls'. 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.tBMH9hVLo() - maybe Microsoft Office is not installed? This Task requires Microsoft Office being installed.
ExecuteProcess("C:\Program Files\VisualCron\\TaskOfficeMacrox86.exe" 257)->Unhandled execution error: System.Runtime.InteropServices.COMException (0x800A03EC): Microsoft Excel cannot access the file 'C:\Freedom\CombineSheets.xls'. 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.tBMH9hVLo()
at TaskOfficeMacro.OfficeMacro.ojEZqVdFd()
at Iw7U8AFDbYsoJbVj4B.HXIcSvWse109OZwest.ju4n6fQmk(String[] )
Exception in Task: ExecuteProcess("C:\Program Files\VisualCron\\TaskOfficeMacrox86.exe" 257)->RunExcelMacro->COMException System.Runtime.InteropServices.COMException (0x800A03EC): Microsoft Excel cannot access the file 'C:\Freedom\CombineSheets.xls'. 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.

But I checked all three points that is listed and I can't figure out why. Please advise and thanks in advance:)
Support
2014-07-19T08:13:00Z
Which path do you use to the excel file?
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Erica
  •  Erica
  • Paid support Topic Starter
2014-07-21T12:26:06Z
c:/Freedom/CombineSheets.xls
Support
2014-07-21T16:46:36Z
Originally Posted by: Erica 

c:/Freedom/CombineSheets.xls



I do not know if it is forgiving or not but in Windows you write like this:

c:\Freedom\CombineSheets.xls
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Erica
  •  Erica
  • Paid support Topic Starter
2014-07-21T16:49:35Z
oh sorry that's what I meant.

For my settings:
Type: Excel
Path: C:\Freedom\Reports\CombineReconcile.xls
Macro name: GetSheets
Scroll to Top