Prev: Message box warning of missing data
Next: Simple shared code library, also how to find spreadsheets with macros in them
From: Richard Burton on 11 Mar 2010 07:14
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
From: Dave Peterson on 11 Mar 2010 08:37
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
From: Jacob Skaria on 11 Mar 2010 08:51
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
 | 
Pages: 1
Prev: Message box warning of missing data
Next: Simple shared code library, also how to find spreadsheets with macros in them