Use VBA to close Excel File without Prompt (without saving)

[Stevenmou]

Hi everyone,

I try to use VBA to close an excel file without saving and without prompt.

I've tried many methods below (pasted below) but still cannot do it without the prompt. I figured it was probably because I am in TM1 Perspectives.

Can anyone please help me find a solution?

Thanks a lot,

'tried method 1:
Application.DisplayAlerts = False
ThisWorkbook.Saved = True

'tried method 2:
Application.DisplayAlerts = False
Activeworkbook.Close SaveChanges:=False

'tried method 3:
Application.DisplayAlerts = False
Activeworkbook.close False

 

[cooper645]

[COLOR=#454545][FONT=&quot]Sub testSave()[/FONT][/COLOR]
[COLOR=#454545][FONT=&quot]Application.DisplayAlerts = False[/FONT][/COLOR]
[COLOR=#454545][FONT=&quot]ThisWorkbook.Save[/FONT][/COLOR]
[COLOR=#454545][FONT=&quot]Application.DisplayAlerts = True[/FONT][/COLOR]
[COLOR=#454545][FONT=&quot]Application.Quit[/FONT][/COLOR]
[COLOR=#454545][FONT=&quot]End Sub[/FONT][/COLOR]

 

[Stevenmou]

Thank you for chiming in, however the saving prompt popped up again. I really need some help to skip the saving prompts. Thx

 

[Stevenmou]

Hi everyone, I found the solution to close a file without prompt as below. Thanks everyone for your help.

with workbooks(filename)'your file name
.saved =True
.Close
End With

 

[Louis_Jr]

Works great however Excel stays open; to close it completely
Replace
. Close
with
.Application.Quit