Excel Msg Suppression

Posted by TC on April 30, 2001 12:42 PM

Anyone out there know a 'easy' way to suppress
the msgs "do you wish to overwrite" and
"this is not xls format do you wish it to be??

The below bring up both msgs?
ActiveWorkbook.SaveAs FileName:="C:\SAMPLES\INDATA2.dbf", FileFormat:= _
xlDBF4, CreateBackup:=False
ActiveWindow.Close

Curious

Posted by Barrie Davidson on April 30, 2001 12:46 PM

Put "Application.DisplayAlerts = False" before your code. This turns off the alert boxes. Don't forget to put "Application.DisplayAlerts = True" after your code.

Posted by tc on April 30, 2001 12:55 PM