View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Can we run Windows Script file from Excel/Office Application

/c tells the OS to close the window when it finishes.

For testing purposes, you may want to use /k to keep the window open.

And if you shell to DOS:
Windows start button|Run
type:
cmd
and hit enter

You can type this and hit enter:
cmd /?
And you'll see a help screen that starts with:

Starts a new instance of the Windows XP command interpreter

CMD [/A | /U] [/Q] [/D] [/E:ON | /E:OFF] [/F:ON | /F:OFF] [/V:ON | /V:OFF]
[[/S] [/C | /K] string]

/C Carries out the command specified by string and then terminates
/K Carries out the command specified by string but remains
......





Gary''s Student wrote:

Have you tried something like:

Sub Macro1()
x = Shell("cmd.exe /c C:\hooklmp.wsf", 1)
End Sub
--
Gary's Student

"PeeDi" wrote:

Hi,

I am creating an Excel Application (Office 2000) where I need to execute a
Windows Script file. It would be better if I could run the script from the
Application with a click of button. I couldnt find a solution for this. I
could run any .exe file using Shell command. But cant run .wsf (windows
script file). Is there any way to do so???

Please reply, if you know this.
--
Help yourself.......Dont wait for GOD...


--

Dave Peterson