Donate SIGN UP
Home > Technology > Excel VBA File save

Excel VBA File save

Avatar Image
medway26 | 16:32 Fri 17th Sep 2004 | Technology
3 Answers
I am trying to program a subroutine that (eventually) saves the workbook. In every case, a file with the same path/name will exist and it has to be overwritten. I get an message saying "file exists, overwrite?". How can I disable this message as I will always want to overwrite?
prev dvd ramto dvd -r
  
next windows media player

Answers

1 to 3 of 3rss feed

Best Answer

No best answer has yet been selected by medway26. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
-- answer removed --
Avatar Image Closer
can't you just use ActiveWorkbook.Save ?
17:12 Fri 17th Sep 2004
Avatar Image dj_ajax
I think the code for it is: excel.application.displayalerts = false then code for saving the file and then: excel.application.displayalerts = true to turn alerts back on
15:39 Sat 18th Sep 2004

1 to 3 of 3rss feed

Related Questions

Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.