How to AutoClose and Save

[WANNABE]

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

 

[Tom Ogilvy]

Sub Auto_Open()

' current code

Thisworkbook.Close SaveChanges:=True
End Sub