Closing Excel Application using VBA

by

I think your problem is that it’s closing the document that calls the macro before sending the command to quit the application.

Your solution in that case is to not send a command to close the workbook. Instead, you could set the “Saved” state of the workbook to true, which would circumvent any messages about closing an unsaved book. Note: this does not save the workbook; it just makes it look like it’s saved.

ThisWorkbook.Saved = True

and then, right after

Application.Quit

More Related Contents:

  1. How to add a custom Ribbon tab using VBA?
  2. filter out multiple criteria using excel vba
  3. How to add parameters to an external data query in Excel which can’t be displayed graphically?
  4. Cannot VBA write data to cells in Excel 2007/2010 within a function
  5. VBA equivalent to Excel’s mod function
  6. Excel VBA to match and line up rows
  7. Excel: the Incredible Shrinking and Expanding Controls [closed]
  8. Excel Date Conversion from yyyymmdd to mm/dd/yyyy
  9. How to programmatically code an ‘undo’ function in Excel-Vba? [duplicate]
  10. How to check whether certain sheets exist or not in Excel-VBA? [duplicate]
  11. Delete all data rows from an Excel table (apart from the first)
  12. How to do a “Save As” in vba code, saving my current Excel workbook with datestamp?
  13. SumIf using Excel VBA
  14. How can I call a macro which contains a loop but only run one iteration of that loop?
  15. Test or check if sheet exists
  16. Copy from one workbook and paste into another
  17. How to copy Outlook mail message into excel using VBA or Macros
  18. For Loop not fully cycling in excel VBA [duplicate]
  19. Excel VBA App stops spontaneously with message “Code execution has been halted”
  20. How to remove all non alphanumeric characters from a string except period and space in excel?
  21. Is VBA an OOP language, and does it support polymorphism?
  22. Export each sheet to a separate csv file
  23. Faster way to remove ‘extra’ spaces (more than 1) from a large range of cells using VBA for Excel
  24. Excel: Searching for multiple terms in a cell
  25. Excel VBA Userform – Execute Sub when something changes
  26. Extract Data from Word Document to an Excel SpreadSheet
  27. ‘1004’: “The sort reference is not valid.”
  28. Select entire column in table using Excel VBA
  29. Reducing WithEvent declarations and subs with VBA and ActiveX
  30. VBA Excel simple Error Handling

Leave a Comment