View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ed Ed is offline
external usenet poster
 
Posts: 399
Default Supress SaveAs dialog box?

I have
Application.DisplayAlerts = False
Application.EnableEvents = False
wb.SaveAs strFName
Application.EnableEvents = True
Application.DisplayAlerts = True

DisplayAlerts suppresses the message that I'm overwriting a file, but will
not keep the SaveAs dialog box from popping up. I'm using XL2000, SP-3.
Any suggestions? Do I have to work through the DIalogs collection and kill
that one if it comes up?

Ed