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 |