View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lucy[_2_] Lucy[_2_] is offline
external usenet poster
 
Posts: 7
Default Close Workbook Programmatically

I need to shut down open Excel workbooks at specific time
(e.g. 1 AM) to start data upload. This code will be
included with every workbook that must be closed before
the upload starts (the workbooks reside on a network
drive, but may stay open on different PC's due to users
no closing them, etc.).

Does anybody know the code or point me to a resource to
the trigger this update at the selected time?

Thanks for your help.

Lucy