How to AutoClose and Save

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

WANNABE - 22 Sep 2006 23:33 GMT

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 to this Message

Tom Ogilvy - 23 Sep 2006 00:25 GMT

Sub Auto_Open()

' current code

Thisworkbook.Close SaveChanges:=True
End Sub

Signature

Regards,
Tom Ogilvy

> 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
[quoted text clipped - 3 lines]
>
> Thanks

Reply to this Message