Q: overwrite during saveas

J

JIM.H.

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

Peo Sjoblom

Try

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


Regards,

Peo Sjoblom
 
Top