Shell Function Runs an executable program and returns a Variant (Double) representing the program's task ID if successful, otherwise it returns zero.
Syntax
Shell(pathname[,windowstyle])
The Shell function syntax has these named arguments
<JavaScript:hhobj_4.Click()> :
Part
Description
pathname
Required; Variant (String). Name of the program to execute and any
required arguments <JavaScript:hhobj_5.Click()> or command-line
<JavaScript:hhobj_6.Click()> switches; may include directory or folder
and drive. On the Macintosh, you can use the MacID function to specify
an application's signature instead of its name. The following example
uses the signature for Microsoft Word:
Shell MacID("MSWD")
windowstyle
Optional. Variant (Integer) corresponding to the style of the window in
which the program is to be run. If windowstyle is omitted, the program
is started minimized with focus. On the Macintosh (System 7.0 or later),
windowstyle only determines whether or not the application gets the
focus when it is run.
The windowstyle named argument has these values:
Constant
Value
Description
vbHide
0
Window is hidden and focus is passed to the hidden window. The vbHide
constant is not applicable on Macintosh platforms.
vbNormalFocus
1
Window has focus and is restored to its original size and position.
vbMinimizedFocus
2
Window is displayed as an icon with focus.
vbMaximizedFocus
3
Window is maximized with focus.
vbNormalNoFocus
4
Window is restored to its most recent size and position. The currently
active window remains active.
vbMinimizedNoFocus
6
Window is displayed as an icon. The currently active window remains
active.
Remarks
If the Shell function successfully executes the named file, it returns
the task ID of the started program. The task ID is a unique number that
identifies the running program. If the Shell function can't start the
named program, an error occurs.
On the Macintosh, vbNormalFocus, vbMinimizedFocus, and vbMaximizedFocus
all place the application in the foreground; vbHide, vbNoFocus,
vbMinimizeFocus all place the application in the background.
Note By default, the Shell function runs other programs
asynchronously. This means that a program started with Shell might not
finish executing before the statements following the Shell function are
executed.
Thank you,
Mitch Lawrence
Lead Applications Analyst
Technical Support - NPR/Automation
CHRISTUS Information Management
*: [EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>
Send a "thank you
<http://intranet.christushealth.org/spiritBuck/Default.asp> " to
someone!
________________________________
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Anastasio, David
-PSC
Sent: Thursday, May 15, 2008 9:13 AM
To: [email protected]
Subject: RE: [Talk] Winzip command line parameters
This code is what I use to copy a file to a new folder and append the
date to the copy. You should be able to use the date logic in your task.
copy c:\dma_test\dma_test.txt
c:\dma_test\backup\dma_test%date:~10,4%%date:~4,2%%date:~7,2%.txt
Thank you,
David Anastasio
Data Reporting Services Specialist
perotsystems(tm)
Facility Information Services
Tenet St. Mary's Medical Center
[EMAIL PROTECTED]
561-882-6115 (office)
561-842-9921(fax)
________________________________
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Shirley Hammack
Sent: Thursday, May 15, 2008 9:57 AM
To: [EMAIL PROTECTED]
Subject: [Talk] Winzip command line parameters
We've just recently purchased Winzip 11.1 and installed the add on that
lets you use command line parameters to automate zipping of files. I
intend to zip files that get a new name every day by having the date
appended. Has anyone else been able to get the syntax put together to
do this?
Shirley Hammack
I.T. Financial Analyst
Duncan Regional Hospital
580-251-8939
"CONFIDENTIALITY NOTICE: This e-mail and any files transmitted with it
are the property of DRH and/or its affiliates, are confidential, and are
intended solely for the use of the individual or entity to whom this
e-mail is addressed. If you are not one of the named recipient(s) or
otherwise have reason to believe that you have received this message in
error, please notify 580.251.8773 and delete this message immediately
from your computer. Any other use, retention, dissemination, forwarding,
printing, or copying of this e-mail is strictly prohibited."
<<image001.jpg>>
