Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 | |||
Date to close file | Excel Worksheet Functions | |||
Hibernate Button | Excel Discussion (Misc queries) | |||
vlookup on close file | Excel Worksheet Functions | |||
Everytime i close an excel file, it creates a new backup file | Excel Discussion (Misc queries) | |||
Close Second Version of Excel file | Excel Discussion (Misc queries) |