ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Can we run Windows Script file from Excel/Office Application (https://www.excelbanter.com/excel-programming/380236-re-can-we-run-windows-script-file-excel-office-application.html)

Dave Peterson

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


All times are GMT +1. The time now is 09:12 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com