DomainKey-Signature: a=rsa-sha1; c=nofws; d=sourceware.org; h=list-id
	:list-unsubscribe:list-subscribe:list-archive:list-post
	:list-help:sender:from:to:subject:date:message-id:content-type
	:content-transfer-encoding:mime-version; q=dns; s=default; b=JTJ
	c6lragDPHSgrgbkgT5D/jfqWmruqlv2MsZYn/i1TfoHPAFvLQiaYs7zMSoUrGX2q
	cDVJJgEAx6zN20l5ZsnlDM/mNI3rdAfw3NOgcliz7KINKk9L9oYZqGan62bdbrab
	eonq2mo9jnRLhJDjCWpm108dilaEF/ME3izTSgD0=
Mailing-List: contact cygwin-help@cygwin.com; run by ezmlm
Sender: cygwin-owner@cygwin.com
Mail-Followup-To: cygwin@cygwin.com
From: "Kertz, Denis (D)** CTR **" <d.kertz@alcatel-lucent.com>
To: "cygwin@cygwin.com" <cygwin@cygwin.com>
Subject: Unable to run excel via cron
Date: Tue, 16 Jun 2015 13:27:48 +0000
Message-ID: <883F2CBBC85A62419E181EB2F0ECF21F45DE3251@US70UWXCHMBA04.zam.alcatel-lucent.com>
Content-Type: text/plain; charset="koi8-r"
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit

We need to run some Excel programs via cron and are using vbscript to do this. šWe have this running on a WinXP machine but are having trouble running on a Win7 machine, but we don't think it is a Win7 problem. 

Here's the script to run a simple test excel program: 

Dim xlApp 
Dim xlWb 
Set xlApp = CreateObject("Excel.application") 
xlApp.Visible = True 
Set xlWb = xlApp.workbooks.Open("c:\Shared\Prospect\Bin\TestExcel.xls") 
xlApp.Quit 
Set xlWb = Nothing 
Set xlApp = Nothing 

Here's how we run this test script from a terminal command prompt: 

c:/Windows/System32/wscript.exe 'c:\cygwin64\home\<cygwinLogin>\tst.vbs' 

This runs fine from a command line prompt but hangs when run as a cron job. šWe have trapped the error message we get when the workbooks.Open is executed and get this: 

Microsoft Office Excel cannot access the file 'c:\Shared\Prospect\Bin\TestExcel.xls'. There are several possible reasons: 

‘ The file name or path does not exist. 
‘ The file is being used by another program. 
‘ The workbook you are trying to save has the same name as a currently open workbook. 

We don't believe any of these possible reasons apply. šIn particular, since it looked like this could be a permission issue, we changed the vbscript to simply copy the TestExcel.xls file and that works fine:

dim filesys
set filesys=CreateObject("Scripting.FileSystemObject")
If filesys.FileExists("c:\Shared\Prospect\Bin\TestExcel.xls") Then
ššššššš filesys.CopyFile "c:\Shared\Prospect\Bin\TestExcel.xls", "c:\cygwin64\home\<cygwinLogin>\"
Else
ššššššš WScript.Echo "file does not exist"
End If

This hanging also happens if we create a new spreadsheet and try to save it (and this works fine from a command line prompt). šSo we can run excel programs from a cron job as long as we don't open an excel program or save a spreadsheet, which means it is useless. 

We also have a couple of other Win7 PCs. šThis problem happens on 2 of the 3 Win7 PCs but works on one of the Win7 PCs. šAll 3 PCs are running Excel 2007 SP3.š Two of these 3 PCs have the exact same version of Excel 2007 and one works and the other doesn't.

Anybody have any idea what could be going on here? šWe only have this cron job problem when running an excel program via vbscript. šWe haven't had any cron job problems with other non-excel scripts. 

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