| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
calling an external vbs file on the worksheet close operation
How do I program to run a file called close.vbs when an excel sheet is
closed. Thanks for the help gordo |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
calling an external vbs file on the worksheet close operation
Try this (adjust the path for "close.vbs" of course)
Private Sub Workbook_WindowDeactivate(ByVal Wn As Window) Shell "C:\WINDOWS\SYSTEM32\WScript.exe C:\Test\close.vbs" End Sub Steve "Gordon Cashmore" wrote in message ... How do I program to run a file called close.vbs when an excel sheet is closed. Thanks for the help gordo |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel close operation | Excel Discussion (Misc queries) | |||
| CALLING A RANGE OF CELLS FROM EXTERNAL SOURCE | Excel Discussion (Misc queries) | |||
| Calling a specific worksheet from a hyperlink in a seperate file. | Excel Worksheet Functions | |||
| Close current Workbook after calling macro in other | Excel Programming | |||
| multi[le file operation | Excel Programming | |||
Linear Mode
