Run VBScript from Excel

[Amy M]

I would like to have a user select a button on an Excel worksheet to run a
VBScript. Can this be done?

 

[ruic]

Is that script external to excel or a VBA script? Please specify.

 

[Amy M]

The script is external in a *.vbs file.

Thanks,
Amy

 

[ruic]

Here's an example that launches Calculator:

' Specifying 1 as the second argument opens the application in
' normal size and gives it the focus.
Dim RetVal
RetVal = Shell("C:\WINDOWS\CALC.EXE", 1) ' Run Calculator

 

[Amy M]

Thanks, it worked with "WScript.exe C:\Temp\TestKeys.vbs" as the parameter.
I appreciate the help.