ExcelBanter - Automatically saving a file

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Automatically saving a file (https://www.excelbanter.com/excel-programming/408577-automatically-saving-file.html)

davethewelder

Automatically saving a file

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

Mike

Automatically saving a file

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

"davethewelder" wrote:

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

davethewelder

Automatically saving a file

Mike, worked a treat. Many Thanks
Davie

"Mike" wrote:

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

"davethewelder" wrote:

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

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