Turn Off Alert Before Overwriting Message Box

[JR_06062005]

In a macro I save a workbook which overwrites another. The problem is every
time the macro is excuted, I get a message box asking if I want to overwrite
the existing file. Is there a way to turn this message off?

I've tried placing the following in my macro, but it has no effect:
Application.AlertBeforeOverwriting = False

[Bob Phillips]

Try preceding with

Application.DisplayAlerts = False

and set back to True afterwards

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"JR_06062005" <[email protected]> wrote in message
news:[email protected]...
> In a macro I save a workbook which overwrites another. The problem is
every
> time the macro is excuted, I get a message box asking if I want to
overwrite
> the existing file. Is there a way to turn this message off?
>
> I've tried placing the following in my macro, but it has no effect:
> Application.AlertBeforeOverwriting = False
>
>

[JR_06062005]

That works. Thanks

"Bob Phillips" wrote:

> Try preceding with
>
> Application.DisplayAlerts = False
>
> and set back to True afterwards
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "JR_06062005" <[email protected]> wrote in message
> news:[email protected]...
> > In a macro I save a workbook which overwrites another. The problem is
> every
> > time the macro is excuted, I get a message box asking if I want to
> overwrite
> > the existing file. Is there a way to turn this message off?
> >
> > I've tried placing the following in my macro, but it has no effect:
> > Application.AlertBeforeOverwriting = False
> >
> >
>
>
>