FlowHeater Demo Video
 
FlowHeater - The Data Import / Export Specialist
 
Welcome, Guest
Username: Password: Remember me
See also the existing examples of using the Excel Adapter , which may answer your question: CSV export with grouping
  • Page:
  • 1

TOPIC:

Open method of Workbooks class failed 4 years 10 months ago #2689

  • Ako Si Aien
  • Ako Si Aien's Avatar 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

Open method of Workbooks class failed 4 years 10 months ago #2690

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 4 years 10 months ago #2693

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

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

  • Page:
  • 1

other Languages

de

FlowHeater Home

de en

Imprint/Contact

Privacy Statement

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

Follow us on

twitter  facebook

YouTube

 de en