Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to AutoClose and Save
Hello again.. I have created and auto_open macro that is schedule to open
and run, but I will need it to close and save next week. Can someone tell me what the code for that is?? I think Sub Auto_Close() and something about save... Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to AutoClose and Save
Sub Auto_Open()
' current code Thisworkbook.Close SaveChanges:=True End Sub -- Regards, Tom Ogilvy "WANNABE" <breichenbach AT istate DOT com wrote in message ... Hello again.. I have created and auto_open macro that is schedule to open and run, but I will need it to close and save next week. Can someone tell me what the code for that is?? I think Sub Auto_Close() and something about save... Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
OnTime+TimeValue + Autoclose | Excel Programming | |||
Autoclose code from Bob Phillips not working for me | Excel Programming | |||
Totally Disabling (^ save ) (Save as) and Save Icon – Which code do I use: | Excel Programming | |||
Workbook Autoclose ... | Excel Discussion (Misc queries) | |||
Break all links on autoclose | Excel Programming |