Forced reboots -- Making Excel save always before file close

[bbotz]

Our IT department installs updates after hours. Many times, these updates
force a machine reboot. I have long jobs that I run overnight using VBA to
send ODBC update queries from Excel to our server. Forcing a reboot loses all
the audit trails I compile while sending the update queries.

Is there a way to force Excel to save a spreadsheet when it gets a forced
reboot message from the network?? Autosave doesn't work because it appears
the machine has to be idle for the autosave to work (plus I lose any data
that I uploaded between autosaves).

 

[rdwj]

difficult one, as the reboot may reside outside excel and not be caught.
However, try either to write a SaveAs in the "ThisWorkbook" object, and
select "BeforeClose" (<Alt>+<F11>, select ThisWorkbook in the Project Window,
Select "Workbook" in the left dropdown and BeforeClose in the right one.

Alternative is to save after x minutes or save at the end of completion of a
piece of code

 

[bbotz]

good idea. forgot about the 'on close' routines. ill implement...