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

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