-
Ako Si Aien
-
Topic Author
-
Offline
-
Posts: 2
-
-
|
Hi do you have any idea why is it that when I try to run a batch file via task scheduler, I get "Open method of Workbooks class failed" error every time the .fhd file tries to open an excel file but when i try to trigger .fhd in the flowheater gui, it does not return that error...
example: run this code via batch file in scheduler
Y:\myloc\flowheater\fhbatch.exe /massdata Y:\myloc\fhd\myflowheaterfile.fhd
returns the output
FlowHeater (R) Batch Modul: Version 3.1.0
Start: 27.04.16 06:04:05
Open method of Workbooks class failed
but when i trigger myflowheaterfile.fhd manually in the flowheater gui, it works.
please help. thanks.
|
Please Log in or Create an account to join the conversation.
Last edit: by Ako Si Aien. Reason: grammar clarify things
|
-
FlowHeater-Team
-
-
Offline
-
Posts: 391
-
-
-
-
|
Hi Ako Si Aien,
This
Excel
automation issue is a bug related to Windows 2008 / Windows 8 and all further version as well.
You can solve this by creating one (on 64 bit operating system two) directories manually.
C:\Windows\SysWOW64\config\systemprofile\ Desktop (only on 64 bit operating systems available)
and
C:\Windows\System32\config\systemprofile\ Desktop
You`ll find more information about here:
Excel 2007 automation on top of a Windows Server 2008 x64
Best wishes
Robert Stark
Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
|
Please Log in or Create an account to join the conversation.
|
Time to create page: 0.108 seconds