- Posts: 2
Open method of Workbooks class failed
- Ako Si Aien
- Topic Author
- Offline
- User
Less
More
8 years 6 months ago - 8 years 6 months ago #2689
by Ako Si Aien
Open method of Workbooks class failed was created by Ako Si Aien
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.
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.
Last edit: 8 years 6 months ago by Ako Si Aien. Reason: grammar clarify things
Please Log in or Create an account to join the conversation.
- FlowHeater-Team
- Offline
- Admin
8 years 6 months ago #2690
by FlowHeater-Team
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.
Replied by FlowHeater-Team on topic Open method of Workbooks class failed
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
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.
- Ako Si Aien
- Topic Author
- Offline
- User
Less
More
- Posts: 2
8 years 6 months ago #2693
by Ako Si Aien
Replied by Ako Si Aien on topic Open method of Workbooks class failed
Hi Robert. It worked. Thank you so much
Please Log in or Create an account to join the conversation.
Time to create page: 0.257 seconds