Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Close Excel Workbook
Hi,
I need to ensure that a user has closed their Excel Workbook. I have added the following code and Excel will do this but insists on asking the user to click a messagebox OK button to note the system is closing. Is there a way around this so that Excel will close even if a user is not there?. The workbook contains other code to ensure all changes are saved after input (via a userform) so I have no need to save the file prior to closing it. The user is made aware when they open the Workbook that it will automatically close after 30 minutes, hence I just need to be able to shut it down remotely when a user has gone home and inadvertently left the file open. Thanks, Mickey ================================================== ====== --- Module Code --- Private Sub KillTheApp() ' ' ThisWorkbook.Close savechanges:=False 'true ??? End Sub ================================================== ====== --- Workbook Code --- Application.OnTime Now + TimeValue("00:30:00"), "KillTheApp" ================================================== ====== |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Close Excel Workbook
One possible alternative is the DisplayAlerts property of the Application
object in Excel. I cannot guarantee it will work in your situation, but it is one option you may want to look into. -- David Lloyd MCSD .NET http://LemingtonConsulting.com This response is supplied "as is" without any representations or warranties. "MBlake" wrote in message ... Hi, I need to ensure that a user has closed their Excel Workbook. I have added the following code and Excel will do this but insists on asking the user to click a messagebox OK button to note the system is closing. Is there a way around this so that Excel will close even if a user is not there?. The workbook contains other code to ensure all changes are saved after input (via a userform) so I have no need to save the file prior to closing it. The user is made aware when they open the Workbook that it will automatically close after 30 minutes, hence I just need to be able to shut it down remotely when a user has gone home and inadvertently left the file open. Thanks, Mickey ================================================== ====== --- Module Code --- Private Sub KillTheApp() ' ' ThisWorkbook.Close savechanges:=False 'true ??? End Sub ================================================== ====== --- Workbook Code --- Application.OnTime Now + TimeValue("00:30:00"), "KillTheApp" ================================================== ====== |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Close Excel Workbook
Cheers David, I'll take a look and see if I can work it out.
Mickey |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
auto close workbook | Excel Discussion (Misc queries) | |||
Auto Close A Workbook...With Two Twists! | Excel Programming | |||
Auto Close A Workbook...With Two Twists! | Excel Programming | |||
Auto Close A Workbook...With Two Twists! | Excel Programming | |||
Auto Close function in Excel | Excel Programming |