VBA to overwrite an existing file

[RichardMGreen]

Hi all

I've code some VBA code which produces an output file from a template.
Now, if I want to run the output more than once, I get an message asking if I want to overwrite the existing file (which I always do).

I've tried turning off displayalerts but it's not working.
Is there any way of turning this message off?

 

[RichardMGreen]

The message is generated when executing the initial save (the line above the close).
I'll change the True to a False though, can't see the point of saving it twice.
I put it in becuase Excel was asking if I wanted to save changes even though I hadn't made any.

 

[Ruddles]

And you've tried:-

Application.DisplayAlerts = False
Application.AlertBeforeOverwriting = False

Individually and together?

That's it - I'm out of ideas!

 

[RichardMGreen]

I have tried them both.
Managed to do a bit of digging about the AlertBeforeOverwriting and it looks like it's for cells and not files. It appears to switch on/off the warning when you drag the contents of one cell into another that already has info in it.