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

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