How To: Excel Macro, Save, Exit, and Close

Sub Saveandclose()
ActiveWorkbook.Save
ActiveWorkbook.Close
ActiveWorkbook.RunAutoMacros Which:=xlAutoClose
Application.Quit
End Sub

This entry was posted on Friday, October 31st, 2008 at 8:01 am and is filed under Software, Tech. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

  1. Ashley Gooch says:
    January 15, 2009 at 2:27 am

    This only closes the worksheet, how do you close down the program aswell

  1. There are no trackbacks for this post yet.

Leave a Reply

Upload Files

You can include images or files in your comment by selecting them below. Once you select a file, it will be uploaded and a link to it added to your comment. You can upload as many images or files as you like and they will all be added to your comment.