Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Forced reboots -- Making Excel save always before file close
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). |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Forced reboots -- Making Excel save always before file close
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" wrote: 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). |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Forced reboots -- Making Excel save always before file close
good idea. forgot about the 'on close' routines. ill implement...
"rdwj" wrote: 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" wrote: 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). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007: How do I disable the 'Do you wish to save changes to...' when I close an un changed file? | Excel Discussion (Misc queries) | |||
How to code the Macro to save and close a file? | Excel Discussion (Misc queries) | |||
Excel 2003: File->Close without saving changes (save menu does no. | Excel Discussion (Misc queries) | |||
File close excel does not ask me to save changes | Excel Discussion (Misc queries) | |||
I can't save a file unless I close all excel instances or it's th. | Excel Discussion (Misc queries) |