[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Condor-users] excel on condor
- Date: Tue, 16 Oct 2007 14:46:06 -0500
- From: "Ben Burnett" <burnett@xxxxxxxxxxx>
- Subject: Re: [Condor-users] excel on condor
You may need to enable Excel macros on all the execute nodes (to my knowledge
most recent Excel installations disable macros by default), which you
may have already done (but could be integrated into jeff.bat).
Secondly, does your VBA script close Excel once it has done running? This might
be part of the reason your job is exhibiting this behavior; that is to say,
Excel may have already done the work you are expecting it to do, but it's
just sitting there waiting for someone to close it.
The final though I had on this, is that when using "USE_VISIBLE_DESKTOP = True"
as Ian suggested, you may need to deal with the initial Excel configuration
because unless you are running as yourself, then Excel will want to
know the user's name and initials, etc. (setting this, I think, should be
possible, again, in jeff.bat using the Windows 'reg' tool [not sure of the
key to change, off the top of my head]).
From: condor-users-bounces@xxxxxxxxxxx [mailto:condor-users-bounces@xxxxxxxxxxx]
On Behalf Of Tkacheff GS14 Jeffrey C
Sent: Tuesday, October 16, 2007 2:05 PM
Cc: Purcell GS14 Daniel F
Subject: [Condor-users] excel on condor
more questions on running excel on condor. I have a sample excel workbook with
embedded VBA. the workbook is setup to start running as soon as excel is
started. I have created a "bat" file that will start excel and the workbook from
the command prompt. I have tested this file from command prompt and it works.
the file (jeff.bat) looks like this; excel sdk2.xls
my submit file looks like this;
universe = vanilla
executable = jeff.bat
getenv = true;
transfer_executable = true
error = c:\sdk2.err
log = c:\sdk2.log
should_transfer_files = yes
when_to_transfer_output = on_exit
transfer_input_files = sdk2.xls
when I condor_submit this file, the job gets started on a selected machine. when
I login on that machine I see the following;
- under task manager I see that excel.exe has started but is not eating up any
- under c:\condor\execute\dir_###, I see a _condor_stderr file, the sdk2.xls and
a condor_exec.bat (which is a copy of the jeff.bat file).
so. it looks like my jeff.bat is being transferred, the workbook sdk2.xls is
being transferred, excel is starting up on the remote machine, but. it is not
executing the sdk2.xls file. if I try double clicking on the condor_exec.bat
file is starts the workbook just fine.
I don't understand why the jeff.bat (condor_exec.bat) is not being properly
executed, it looks it is running the first word (excel) in the bat file and not
the argument (sdk2.xls).
any words of wisdom on this?
MAA Branch, Operations Analysis Division, MCCDC
v: 703 784 0429 DSN 278
f: 703 784 3547
"All truth passes through three stages.
First, it is ridiculed.
Second, it is violently opposed.
Third, it is accepted as being self-evident."
- Arthur Schopenhauer (1788-1860)