1、导出EXCEL避免出现保存对话框 在SaveAs的前后各加一句 Application.DisplayAlerts = False ......SaveAs Application.DisplayAlerts = True