Q: overwrite during saveas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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


Regards,

Peo Sjoblom
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

save & backup file 2
C# System.IO.File.Move () with "Access denied" error 3
SaveAs in Macro 2
Excel SaveAs to force overwrite of extant file 1
VBA to automatically test for file, update, overwrite 3
SaveAs *.txt - Outputting with Text quantifiers 4
Save As / Overwrite 4
SaveAs method error 3

Back
Top