Save As without overwrite prompt
 

I want to overwrite an old file without getting prompted as to whether it's
OK.

Is there something I can specify on the SaveAs command? Or do I delete the
old file first (if it's there)?

--
Thanks,
Fred
Please reply to newsgroup, not e-mail

Save As without overwrite prompt
 

Hi,

use the

application.displayalerts = false
thisworbook.save
application.displayalerts = true

--
Mucho gusto,

Cesar Zapata



Fred Smith wrote:
I want to overwrite an old file without getting prompted as to whether it's
OK.

Is there something I can specify on the SaveAs command? Or do I delete the
old file first (if it's there)?

Save As without overwrite prompt
 

a nitpick, but you shouldn't need that with save for a workbook that has
been previously saved, but as the OP specified SAVEAS

application.displayalerts = false
thisworbook.saveas . . .
application.displayalerts = true


--
Regards,
Tom Ogilvy

"Cesar Zapata" wrote in message
...
Hi,

use the

application.displayalerts = false
thisworbook.save
application.displayalerts = true

--
Mucho gusto,

Cesar Zapata



Fred Smith wrote:
I want to overwrite an old file without getting prompted as to whether
it's
OK.

Is there something I can specify on the SaveAs command? Or do I delete
the
old file first (if it's there)?