SyntaxFix

Write A Post

Hire A Developer

Questions

Tags

[excel] Excel 2010 VBA - Close file No Save without prompt

I want to close a Excel 2010 file with VBA.. but when the code runs, it shows a prompt confirmation.... i dont want to see this prompt..

didnt work:

Application.DisplayAlerts = False

ActiveWorkbook.Close SaveChanges:=False

is there a way to do this?

This question is related to excel excel-2010 vba

The answer is

If you're not wanting to save changes set savechanges to false

    Sub CloseBook2()
        ActiveWorkbook.Close savechanges:=False
    End Sub

for more examples, http://support.microsoft.com/kb/213428 and i believe in the past I've just used

    ActiveWorkbook.Close False

Source: Stackoverflow.com

Examples related to excel

• Python: Pandas pd.read_excel giving ImportError: Install xlrd >= 0.9.0 for Excel support • Converting unix time into date-time via excel • How to increment a letter N times per iteration and store in an array? • 'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine. (System.Data) • How to import an Excel file into SQL Server? • Copy filtered data to another sheet using VBA • Better way to find last used row • Could pandas use column as index? • Check if a value is in an array or not with Excel VBA • How to sort dates from Oldest to Newest in Excel?

Examples related to excel-2010

• Get list of Excel files in a folder using VBA • filter out multiple criteria using excel vba • Swap x and y axis without manually swapping values • Excel 2010 VBA - Close file No Save without prompt • Removing special characters VBA Excel • Creating a list/array in excel using VBA to get a list of unique names in a column • Excel formula to get week number in month (having Monday) • Excel VBA Run-time Error '32809' - Trying to Understand it • IF statement: how to leave cell blank if condition is false ("" does not work) • Excel how to find values in 1 column exist in the range of values in another

Examples related to vba

• Copy filtered data to another sheet using VBA • Better way to find last used row • Check if a value is in an array or not with Excel VBA • Creating an Array from a Range in VBA • Excel: macro to export worksheet as CSV file without leaving my current Excel sheet • VBA: Convert Text to Number • What's the difference between "end" and "exit sub" in VBA? • Rename Excel Sheet with VBA Macro • Extract Data from PDF and Add to Worksheet • Quicker way to get all unique values of a column in VBA?