FlowHeater Demo Video
 
FlowHeater - The Data Import / Export Specialist
 
Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Batch module - excel issue

Batch module - excel issue 6 years 1 month ago #2251

  • Gennaro
  • Gennaro's Avatar Topic Author
  • Offline
  • Posts: 27
I wrote a simple script to run the batch module, I scheduled the script run via Windows scheduling task application, but I am encountering the following error (from the batch program debug):

MS Excel could not be startet. One reason can be, Excel is not installed on this computer?


While if I run the script manually, everything works fine.


any ideas?


thanks in advance

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

Re:Batch module - excel issue 6 years 1 month ago #2253

Hi Gennaro,

It could be three possible reasons:
  1. You try to run the scheduled task without user/password login information? For excel you need a windows user logon profile.
  2. Your (scheduled task) user hasn’t enough rights.
  3. If you have created a new user for the scheduled task you have first to logon with this user and start Excel manually one time.

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.

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.

Re:Batch module - excel issue 6 years 1 month ago #2254

  • Gennaro
  • Gennaro's Avatar Topic Author
  • Offline
  • Posts: 27
You are right.

After reviewing the event log, I found an error in COM Server for Microsoft Office Excel Application:

The machine-default permission settings do not grant Local Activation permission for the COM Server application with CLSID
{00024500-0000-0000-C000-000000000046} to the user XXXXXXXXXXXXXXXXXX SID (S-1-5-21-818223188-3440559113-342323212-11453).
This security permission can be modified using the Component Services administrative tool.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.


thanks!

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

Re:Batch module - excel issue 6 years 1 month ago #2257

  • Gennaro
  • Gennaro's Avatar Topic Author
  • Offline
  • Posts: 27
It was a COM permissions problem.

I solved via:

Start > Run > dcomcnfg (or “mmc -32″ and then add the Component Services snap-in manually if you can’t find the app under step 3)

Navigate to Component Services > Computers > My Computer > DCOM Config

Locate the MS application giving you trouble (eg: “Microsoft Excel Application” for Excel or “Microsoft Word 97 – 2003 Document” for Word)

Right click > Properties

On the security tab: Select Customize under Launch and Activation Permissions and click Edit…

Add the account under which the site is running (eg: Network Service) and assign Local Launch & Local Activation permissions

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

  • Page:
  • 1

other Languages

en
GB | US

de
DE | AT | CH

FlowHeater Home

de en

Imprint/Contact

Privacy Statement

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

Follow us on

twitter  facebook

YouTube

 de en