Before the SaveAs, enter:
Application.DisplayAlerts = False

Bob Umlas
Excel MVP

-----Original Message-----
How do I use the SaveAs method and suppress the overwrite
YesNoCancel
dialog when the same file already exists?
Is there any other way to achieve this?
thanks
Peter
.