Automatically saving a file

  • Thread starter Thread starter davethewelder
  • Start date Start date
D

davethewelder

Hi, I wish to save a file which opens with a macro without the "do you wish
to replace this file" prompt appearing. File is an update of the scheduled
excel spreadsheet from an oracle database.

Thanks and regards,

Davie
 
Try this:
Application.DisplayAlerts = False
ActiveWorkbook.Save
Application.DisplayAlerts = True
 

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

To remove the promt question message in a Save As method 2
Excel SaveAs to force overwrite of extant file 1
Which Oracle home does VBA use? 1
Saving files automatically 2
Insert, copy, update, delete records through VBA 3
Lose macros before saving 4
Saving information to PERSONAL.XLS 1
Opening Text Files and Re-Saving Them 1

Back
Top