X-Recipient:	archive-cygwin AT delorie DOT com
DomainKey-Signature:	a=rsa-sha1; c=nofws; d=sourceware.org; h=list-id
	:list-unsubscribe:list-subscribe:list-archive:list-post
	:list-help:sender:mime-version:in-reply-to:references:date
	:message-id:subject:from:to:content-type
	:content-transfer-encoding; q=dns; s=default; b=JKAZMoic2INVKKpu
	/UD79oPs8QUhJ6TEUiyDOuoTi33cxXNBtAFmVSd0IJjPLvyUV4s53ju6sF21F0kb
	0pwYnKphOaCumfHDG79ENl5T/DMP0GbuWVW6xDHhoWvdY32/9sXSORTeIWB4dODS
	LHEjfaLYrTqKrA3jvbbqtOudITo=
DKIM-Signature:	v=1; a=rsa-sha1; c=relaxed; d=sourceware.org; h=list-id
	:list-unsubscribe:list-subscribe:list-archive:list-post
	:list-help:sender:mime-version:in-reply-to:references:date
	:message-id:subject:from:to:content-type
	:content-transfer-encoding; s=default; bh=81mYEhZrVLMsrZT6SJugdt
	UcUWM=; b=jYiEkD23OYm4jMaea1bdb3owFup9JLgM5eRyu87lg8rzdwSMhK17Zh
	P4BBykmtKQKRj7xe06D31hCp3AF2tw5HLhQkvEct2BejdzyQvjTMCCu9fra4mMYK
	GG1GuxDGFFn9Y+DCoLylNz7fmAjECUll60TU9koadQsbUgc70JLhc=
Mailing-List:	contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Id:	<cygwin.cygwin.com>
List-Subscribe:	<mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive:	<http://sourceware.org/ml/cygwin/>
List-Post:	<mailto:cygwin AT cygwin DOT com>
List-Help:	<mailto:cygwin-help AT cygwin DOT com>, <http://sourceware.org/ml/#faqs>
Sender:	cygwin-owner AT cygwin DOT com
Mail-Followup-To:	cygwin AT cygwin DOT com
Delivered-To:	mailing list cygwin AT cygwin DOT com
Authentication-Results:	sourceware.org; auth=none
X-Virus-Found:	No
X-Spam-SWARE-Status:	No, score=-0.5 required=5.0 tests=AWL,BAYES_20,FREEMAIL_FROM,FREEMAIL_REPLY,RCVD_IN_DNSWL_LOW,SPF_PASS autolearn=no version=3.3.2
X-HELO:	mail-ig0-f182.google.com
MIME-Version:	1.0
X-Received:	by 10.42.224.69 with SMTP id in5mr873031icb.19.1415824299466; Wed, 12 Nov 2014 12:31:39 -0800 (PST)
In-Reply-To:	<883F2CBBC85A62419E181EB2F0ECF21F3E118128@US70UWXCHMBA04.zam.alcatel-lucent.com>
References:	<883F2CBBC85A62419E181EB2F0ECF21F3E1169F8 AT US70UWXCHMBA04 DOT zam DOT alcatel-lucent DOT com> <1785488620 DOT 20141111221749 AT yandex DOT ru> <883F2CBBC85A62419E181EB2F0ECF21F3E118128 AT US70UWXCHMBA04 DOT zam DOT alcatel-lucent DOT com>
Date:	Wed, 12 Nov 2014 13:31:39 -0700
Message-ID:	<CAFWoy7GVWvKe9SFFM7hLZzRTiDXXfJSxppf-mTE+L72OFpCEYw@mail.gmail.com>
Subject:	Re: Can't Run Excel From A Cron Job Under Windows 7
From:	Keith Christian <keith1christian AT gmail DOT com>
To:	cygwin AT cygwin DOT com
X-IsSubscribed:	yes
X-MIME-Autoconverted:	from quoted-printable to 8bit by delorie.com id sACKVwXJ006318

Denis,

If Excel is starting a macro in the worksheet, it might be worth
adding some logging to the visual basic code.  Perhaps try this in
your Excel macro code if that is where the processing is taking place:



'--- Set up variables near the top of your macro.
'---   (Check whether you want the macro to set the current directory
(ChDir strPath) to that of the workbook.)
strPath = ThisWorkbook.Path
ChDir strPath
strLogFilename = strPath & "\" & "loggingfile.txt"


'--- Insert this block at various areas in the macro code
'--- Helps ensure logfile isn't discarded during a hang by
'---   using "Append" mode and flushing/closing immediately after
messages is written.
Open strLogFilename For Append As #2
    strLogMessage = Now & " ---- " & "Current directory is " & strPath
Print #2, strLogMessage
Close #2



Keith


On Wed, Nov 12, 2014 at 9:20 AM, Kertz, Denis (D)** CTR **
<d DOT kertz AT alcatel-lucent DOT com> wrote:
>>> An excel program is run like this:
>>
>>>         run.excel  'c:\Shared\Bin\Create_Daily_Scorecard.xls'
>>
>>> When I run an Excel program interactively with this run.excel script it
>>> runs just fine but when I run it via a cron job Excel just hangs.
>>
>> Define "runs fine" please?
>> What exactly that excel script is doing?
>
> This run.excel script simply starts up Excel with the .xls file it is given.  In this example Excel opens c:\Shared\Bin\Create_Daily_Scorecard.xls.  This .xls has a Workbook_Open macro, which is automatically run whenever this .xls is opened, that reads some data files and creates another .xls as its output.
>
> What I mean by runs fine is that when I type this command at a bash prompt:
>         run.excel  'c:\Shared\Bin\Create_Daily_Scorecard.xls'
> it runs to completion and creates a new .xls as its output.  When I run this run.excel script from a cron job it hangs.
>
>>> When Excel hangs I can look at the processes running on the PC using the
>>> Windows Task Manager and I don't see the EXCEL.EXE process.  But when I
>>> check the option to show processes from all users I see the hung EXCEL.EXE
>>> process, AND the user name displayed is my login.  So I am running this under the
>>> Upar2 login and Task Manager doesn't display EXCEL.EXE as a Upar2 process
>>> but when I check 'Show processes from all users' it shows EXCEL.EXE running
>>> under user name Upar2 - a contradiction.
>>
>> Task manager display processes started in your current session.
>> Not processes started under your credentials. That's an important difference.
>
> Then this is just a difference between WinXP and Win7?  Under WinXP it shows EXCEL.EXE in my process list even when the "Show processes from all users" isn't checked.
>
>>> What I suspect is happening is Excel is attempting to do something that
>>> requires Upar2 permission but it isn't really running as Upar2 so Excel
>>> displays some error message and is waiting for the user to respond.  But
>>> Excel is running invisibly so this can't be seen.
>>
>> More like you expect to run Excel interactively from service.
>> Not possible. Period.
>
> I'm not trying to run Excel interactively from a cron job.  One of the limitations with using Excel from a cron job is Excel has to run error free.  If Excel does run into some error it will typically generate an error message and wait for a user response.  Since Excel is running invisibly from a cron job, there is no user to give a response and Excel just sits there waiting for a response that will never come.
>
>>> I also suspect this Upar2 "confusion" isn't limited to running an Excel
>>> program.  I can run a cron job with regular UNIX commands (cut, sort, etc)
>>> and see they are running with the ps command.  But when I try to kill them
>>> (kill -9) I get permission denied.  If I want to kill a process running via
>>> the cron I have to start cygwin with 'Run as administrator' and then I can
>>> kill processes running under the cron.
>>
>> Of course.
>
> Why "of course"?  Shouldn't I be able to kill my own processes?  I can certainly do that under WinXP.  But this isn't a major issue for me.  I only pointed it out in case it was related to the issue why my Excel cron jobs hang.
>
> --
>> WBR,
>> Andrey Repin (anrdaemon AT yandex DOT ru) 11.11.2014, <22:14>
>>
>> Sorry for my terrible english...
>
> Nothing wrong with your English...
>
> Denis
>
>
> --
> Problem reports:       http://cygwin.com/problems.html
> FAQ:                   http://cygwin.com/faq/
> Documentation:         http://cygwin.com/docs.html
> Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
>

--
Problem reports:       http://cygwin.com/problems.html
FAQ:                   http://cygwin.com/faq/
Documentation:         http://cygwin.com/docs.html
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple

- Raw text -