| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Run VBScript from Excel
I would like to have a user select a button on an Excel worksheet to run a
VBScript. Can this be done? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Run VBScript from Excel
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Run VBScript from Excel
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Run VBScript from Excel
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| help with vbscript to average a report of dates | Excel Discussion (Misc queries) | |||
| Anoth vbscript question ... sorry ! | Setting up and Configuration of Excel | |||
| Writing Macros In VBScript | Excel Discussion (Misc queries) | |||
| conditional formatting + VBscript | Excel Discussion (Misc queries) | |||
| Saving an entire workbook as a PDF using VBSCript | Excel Worksheet Functions | |||
Linear Mode
