Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to close file and hibernate? | Excel Discussion (Misc queries) | |||
How to hibernate Windows XP at the end of macro? | Excel Programming | |||
Hibernate Button | Excel Discussion (Misc queries) | |||
Hibernate via VBA | Excel Programming | |||
Hibernate using Excel macro | Excel Programming |