"No Ask" or "No Warnings" state in Project VBA?

[G Lykos]

Greetings! Am using a macro to execute a series of exports from schedule
files to Excel spreadsheets. If run manually, and if the spreadsheet file
already exists, a dialog box pops up to advise such and ask if overwriting
is desired. If run automatically, the macro simply stops with error. Is
there an "no ask" or "no warnings" option or state into which the macro can
be put such that it go ahead and overwrite existing files?

Thanks,
George

 

[Rod Gill]

Try:
Application.Displayalerts=false

then at the end of the macro you need to turn them on again:
Application.Displayalerts=true