View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Cesar Zapata[_3_] Cesar Zapata[_3_] is offline
external usenet poster
 
Posts: 10
Default 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)?