ExcelBanter - Q: overwrite during saveas

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Q: overwrite during saveas (https://www.excelbanter.com/excel-discussion-misc-queries/3086-q-overwrite-during-saveas.html)

JIM.H.

Q: overwrite during saveas

I use ActiveWorkbook.SaveAs desFile in my module and I need to get this work
without prompt even if the file exists

Peo Sjoblom

Try

application.displayalerts = false
ActiveWorkbook.SaveAs desFile
application.displayalerts = true

Regards,

Peo Sjoblom

"JIM.H." wrote:

I use ActiveWorkbook.SaveAs desFile in my module and I need to get this work
without prompt even if the file exists

All times are GMT +1. The time now is 05:37 PM.