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