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
|