G Gordon Cashmore Nov 7, 2003 #1 How do I program to run a file called close.vbs when an excel sheet is closed. Thanks for the help gordo
How do I program to run a file called close.vbs when an excel sheet is closed. Thanks for the help gordo
S Steve Yandl Nov 7, 2003 #2 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
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
