Thread: Help with a closing WB w/o activity!
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Greg Wilson Greg Wilson is offline
external usenet poster
  
Posts: 747
Default Help with a closing WB w/o activity!
When I changed the wait time from seconds to minutes I made a mistake. In
procedure TestForShutDown, change the line

KillTime = Now + 10 / 1440

to

KillTime = Now + 0.1 / 1440

Also change "seconds" to "minutes" in the workbook_open message.

Regards,
Greg
Reply With QuoteReply With Quote