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)?
|