I have the [ Application.DisplayAlerts = False ] statement right before the [
ActiveWorkbook.Close(0) ] statement
For some reason, it didn't prevent the prompted msg asking the user  if file
needed to be saved.

What is the purpose of the ( ActiveWorkbook.Saved = True ) statement ?

If the Excel file  is already saved or doesn't need to saved.
The ActiveWork.Close(0) closes the workbook, however the prompted msg asking if
Excel file needs to be saved is displayed...( sigh )