|Title||Automatically save and exit Excel after running a macro|
|Versions affected||4.0 and later|
|Description||User needs to run Excel Macro. Then save and exit the Excel Workbook.|
|Solution||The desired macro needs
to be edited in the Excel Visual Basic Editor using the following steps:
0. Backup your excel worksheet just in case...
1. Use Tools->Macro->Macros->Edit to edit your macro in the visual basic editor
2. Before the 'End Sub' line in your macro, add the following line:
Application.OnTime Now + TimeValue("00:00:05"), "Save_Exit"
3. Add the function Save_Exit() from below, just after the 'End Sub' line of your macro.
Example 1: The following example will save & exit Excel 5 seconds after the macro finishes running.
Example 2: The following example will save & exit Excel 5 minutes after the macro starts running. This way, the excel file will always close even if the macro hangs