Save As... Can't disable confirmation box

[DEMI224]

I'm running a code that is supposed to automatically save the output, but I can't seem to get rid of the confirmation box. Apparently Application.DisplayAlerts = False isn't working for me. I have a code that's basically:

Sub code()

Application.DisplayAlerts = False

code code code

ActiveWorkbook.SaveAs Filename:=fname, FileFormat:=xlNormal, CreateBuckup:=False

ActiveWorkbook.Close False

Application.DisplayAlerts = True

End Sub

I can't find anyone else on this forum or a number of others that's had this issue... any ideas why?

 

[BobUmlas]

Try putting the DisplayAlerts immediately before the SaveAs. Also change CreateBuckup to CreateBackup (unlikely the culprit but...)

 

[DEMI224]

Done and done.... sadly, no improvement... I've also tried with EnableEvents = True and False...