VBA Close workbook without saving message box

[Diogenes]

Hi all,
I am trying to close a workbook that I have just copied data from and I don’t want to receive the “do I want to close without saving” message.
The section of code in question currently looks like this:

    ' Close customer workbook
    customerWorkbook.Activate
    Application.CutCopyMode = False
    customerWorkbook.Close , SaveChanges = False
       
    targetSheet.Activate

I still get the message every time any idea why?
I am using excel 2007.
Many thanks,

 

[Worzul]

Hi there,

I've not tested this but used something similar on other workbooks.

   ' Close customer workbook
    customerWorkbook.Activate
    Application.CutCopyMode = False
    
    Application.DisplayAlerts = False
    
    customerWorkbook.Close , SaveChanges = False
    
    Application.DisplayAlerts = True
       
    targetSheet.Activate

 

[VoG]

Try

Application.DisplayAlerts = False
customerWorkbook.Close SaveChanges:=False ' No comma, := not =
Application.DisplayAlerts = True

 

[Diogenes]

Thanks for the quick replies guys.
My code now looks like this:

    ' Close customer workbook
    customerWorkbook.Activate
    Application.CutCopyMode = False
    Application.DisplayAlerts = False
    customerWorkbook.Close SaveChanges:=False
    Application.DisplayAlerts = True
      
    targetSheet.Activate

I am still getting the same message!
Could it be something in my setup of my version of excel around saving i.e. in the options somewhere?
Thanks again,

 

[VoG]

Sledgehammer approach

' Close customer workbook
    customerworkbook.Activate
    customerworkbook.Saved = True ' marks as saved but doesn't save
    Application.CutCopyMode = False
    Application.DisplayAlerts = False
    customerworkbook.Close SaveChanges:=False
    Application.DisplayAlerts = True
      
    targetSheet.Activate

 

[Diogenes]

That works perfectly - thank you so much!

 

[Worzul]

Evan I've learn't something new there, thanks VoG.

 

[zombiemaster]

This helped me as well - thanks as always VoG for a great answer, and thanks Diogenes for asking the question!