Drove me crazy too.
xl = win32com.client.DispatchEx("Excel.Application") xl.DisplayAlerts = False # Suppress all alerts
This overrides the dialogue boxes and closes just using:
wb.Close()