How to close file and hibernate?
in [General]
|
From: Eric on 30 Apr 2010 16:32 I would like to close existing file and go hibernate, but once this file is closed, the command hibernate cannot be run. On the other way, I run the hibernate, which work, but the file cannot be closed. Does anyone have any suggestions on how to close file and hibernate XP? My PC is XP with SP3 and using office 2003 Thanks in advance for any suggestions Eric Workbooks("Update Up.xls").Close savechanges:=True hibernate Public Sub hibernate() 'ShutDownHibernate 'Go into hibernate, force it, but don't disable wake events SetSuspendState 1, 1, 0 End Sub
From: Bob I on 4 May 2010 11:39 Perhaps run a CMD file listing what should be done afer save changes is complete containing Kill EXCEL Hibernate. Eric wrote: > I would like to close existing file and go hibernate, but once this file is > closed, the command hibernate cannot be run. On the other way, I run the > hibernate, which work, but the file cannot be closed. > Does anyone have any suggestions on how to close file and hibernate XP? > My PC is XP with SP3 and using office 2003 > Thanks in advance for any suggestions > Eric > > Workbooks("Update Up.xls").Close savechanges:=True > hibernate > > Public Sub hibernate() > 'ShutDownHibernate > 'Go into hibernate, force it, but don't disable wake events > SetSuspendState 1, 1, 0 > End Sub >
From: Billns on 4 May 2010 14:44 On 4/30/2010 1:32 PM, Eric wrote: > I would like to close existing file and go hibernate, but once this file is > closed, the command hibernate cannot be run. On the other way, I run the > hibernate, which work, but the file cannot be closed. > Does anyone have any suggestions on how to close file and hibernate XP? > My PC is XP with SP3 and using office 2003 > Thanks in advance for any suggestions > Eric > > Workbooks("Update Up.xls").Close savechanges:=True > hibernate > > Public Sub hibernate() > 'ShutDownHibernate > 'Go into hibernate, force it, but don't disable wake events > SetSuspendState 1, 1, 0 > End Sub > Looks like your macro won't finish once you close Excel. There's a shortcut sequence that will put your machine into hibernate: Start key - u - shift-h The start key brings up Windows start menu, u selects "Turn off computer" and shift-h puts you into hibernate. Bill
|
Pages: 1 Prev: Smooth out pie Next: Forecast with two unknown variables |