View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Amy M[_2_] Amy M[_2_] is offline
external usenet poster
 
Posts: 2
Default Run VBScript from Excel

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

"ruic" wrote:

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


--
Rui


"Amy M" wrote in message
...
The script is external in a *.vbs file.

Thanks,
Amy

"ruic" wrote:

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

--
Rui


"Amy M" <Amy wrote in message
...
I would like to have a user select a button on an Excel worksheet to run
a
VBScript. Can this be done?