VBA workbooks.Close without being prompted to if the user wants to save?

by

Try using ThisWorkbook.Saved = True

        Application.DisplayAlerts = False
        currentBook.SaveAs Filename:=fileNameS, FileFormat:=xlCSV, ConflictResolution:=xlLocalSessionChanges
        currentBook.Saved = True            
        currentBook.Close SaveChanges:=False
        Application.DisplayAlerts = True

More Related Contents:

  1. Sequence of numbers based on start and end value of 2 cells [closed]
  2. Function to convert column number to letter?
  3. Read/Parse text file line by line in VBA
  4. Better way to find last used row
  5. 2 Dimensional array from range [closed]
  6. filter out multiple criteria using excel vba
  7. Excel VBA autofilter all but three
  8. How can I create a calendar input in VBA Excel?
  9. Using Google Chrome in Selenium VBA (Installation Steps)
  10. Dir() function not working in Mac Excel 2011 VBA
  11. Excel VBA code to copy a specific string to clipboard
  12. How to use workbook.saveas with automatic Overwrite
  13. Range limit conundrum
  14. How do you run a .exe with parameters using vba’s shell()?
  15. How to determine the last Row used in VBA including blank spaces in between [duplicate]
  16. How to use FindWindow to find a visible or invisible window with a partial name in VBA
  17. How do you get a Range to return its Name?
  18. Passing variable from Form to Module in VBA
  19. How to give a time delay of less than one second in excel vba?
  20. Excel VBA: Convert a date string to a Unix timestamp
  21. excel to pdf ignores print area and calls printer
  22. In Excel, can I use a hyperlink to run vba macro?
  23. Countif With Multiple OR Criteria
  24. Vlookup to copy color of a cell
  25. excel vba freeze pane without select
  26. How to delete rows in Excel based on criteria using VBA?
  27. Converting a string representation of a constant into a constant?
  28. Macro to export MS Word tables to Excel sheets
  29. VBA WinHTTP to download file from password proteced https website
  30. How to protect Excel workbook using VBA?

Leave a Comment