Saving files automatically
 

Hi,

I have a macro to save a number of different versions of my file for
different budget holders. When this is run, it recognises that the file
already exists and prompts to allow it to be overwritten. Is there some VBA I
can add to accept the prompt automatically?

Thanks

Richard

Saving files automatically
 

application.displayalerts = false
'your code to save
application.displayalerts = true



Richard Burton wrote:

Hi,

I have a macro to save a number of different versions of my file for
different budget holders. When this is run, it recognises that the file
already exists and prompts to allow it to be overwritten. Is there some VBA I
can add to accept the prompt automatically?

Thanks

Richard

--

Dave Peterson

Saving files automatically
 

Application.DisplayAlerts = False
Activeworkbook.SaveAs filename
Application.DisplayAlerts = True

--
Jacob


"Richard Burton" wrote:

Hi,

I have a macro to save a number of different versions of my file for
different budget holders. When this is run, it recognises that the file
already exists and prompts to allow it to be overwritten. Is there some VBA I
can add to accept the prompt automatically?

Thanks

Richard