Skip to main content
simply more productive

The Data Specialist

Thanks to our intuitive transformation designer, you can convert data effortlessly to a variety of formats without knowing how to program. It’s not only efficient, it’s also easy to use.
Flowheater Chart

Open method of Workbooks class failed

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.
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.

More
8 years 6 months ago #2690 by FlowHeater-Team
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

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.

More
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
FlowHeater Logo

FlowHeater - The Data Specialist

Efficient data integration and transformation with FlowHeater – the perfect solution for a seamless transfer of your data.

Legal information

Support & Contact

Contact

Phone:
0951 / 9933 9792

eMail:
This email address is being protected from spambots. You need JavaScript enabled to view it.


Copyright © 2009-2024 by FlowHeater GmbH. All rights reserved.