Close Workbook with VB (2000)

Topic

New Reply

When I use the code ActiveWorkbook.Close in a macro, what is the VB code to say “No” to the question “Do you want to save the changes you have made to Sheet1?”?

Reply | Quote

Replies

Try:

    Application.DisplayAlerts = False
    ActiveWorkbook.Saved = True
    ActiveWorkbook.Close
    Application.DisplayAlerts = True

Reply | Quote

Try:

    Application.DisplayAlerts = False
    ActiveWorkbook.Saved = True
    ActiveWorkbook.Close
    Application.DisplayAlerts = True

Reply | Quote

Or try this alternative

ActiveWorkbook.Close SaveChanges:=False

Andrew C

Reply | Quote

OR the even shorter:

ActiveWorkbook.Close (False)

Steve

Reply | Quote

Shortest :

Activeworkbook.Close False

Reply | Quote

Even shorter

Activeworkbook.Close 0

Andrew

Reply | Quote

You win!

Reply | Quote

You win!

Reply | Quote

Even shorter

Activeworkbook.Close 0

Andrew

Reply | Quote

Shortest :

Activeworkbook.Close False

Reply | Quote

OR the even shorter:

ActiveWorkbook.Close (False)

Steve

Reply | Quote

Or try this alternative

ActiveWorkbook.Close SaveChanges:=False

Andrew C

Reply | Quote