Force Save over existing file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

XCESIV - 25 May 2006 03:08 GMT

I have a macro that i have made that saves to a temp file. I want to
set the macro to automatically save to this file regardless if the file
already exists.

I have had a play with it and search on here and couldnt find the
anser.

Can someone please help.

Ty

Signature

XCESIV

Reply to this Message

Norman Jones - 25 May 2006 03:21 GMT

Hi XCESIV,

Try:

Application.DisplayAlerts = False

'Your save code

Application.DisplayAlerts = True

---
Regards,
Norman

> I have a macro that i have made that saves to a temp file. I want to
> set the macro to automatically save to this file regardless if the file
[quoted text clipped - 6 lines]
>
> Ty

Reply to this Message

FSt1 - 25 May 2006 03:24 GMT

hi.
add this to your macro before the save as command...

Application.DisplayAlerts = False

then be sure to turn alerts back on after the save as.

Application.DisplayAlerts = True

regards.
FSt1

> I have a macro that i have made that saves to a temp file. I want to
> set the macro to automatically save to this file regardless if the file
[quoted text clipped - 6 lines]
>
> Ty

Reply to this Message

ADG - 25 May 2006 08:51 GMT

You can also use

Application.AlertBeforeOverwriting = False

Which leaves other alerts on

Signature

Tony Green

> I have a macro that i have made that saves to a temp file. I want to
> set the macro to automatically save to this file regardless if the file
[quoted text clipped - 6 lines]
>
> Ty

Reply to this Message