Dynamic data import / export

datenbank

simply more productive
Up to 100,000 records can be processed with the freeware version!
Welcome, Guest
Username: Password: Remember me
Welcome to the FlowHeater support forum.

Questions about using FlowHeater are answered here.
  • Page:
  • 1

TOPIC: Open method of Workbooks class failed

Open method of Workbooks class failed 10 months 3 weeks ago #2689

  • Ako Si Aien
  • Ako Si Aien's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • 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

Open method of Workbooks class failed 10 months 3 weeks ago #2690

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 254
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

Please Log in or Create an account to join the conversation.

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.

Open method of Workbooks class failed 10 months 3 weeks ago #2693

  • Ako Si Aien
  • Ako Si Aien's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 2
Hi Robert. It worked. Thank you so much :)

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
Moderators: FlowHeater-Team
Time to create page: 0.080 seconds