VBA Code to Select "Yes" in Yes/No dialog box

Question

Hello

I have below VBA code:

  Dim Text As String

  Text = "D:\Folder\Text"

  ActiveSheet.SaveAs Filename:=Text, FileFormat:=xlTextMSDOS

  End Sub

Above Macro is stopped because "text" already exists in D:\folder as per dialog box: (do you want to replace).

what is the code should I incorporate in above code to select "yes" automatically ?

Thanks

Answer 1

Two choices:

1.  Prevent the dialog from showing:

Application.DisplayAlerts = False

 ActiveSheet.SaveAs Filename:=Text, FileFormat:=xlTextMSDOS

Application.DisplayAlerts  = True

2. Get rid of the old file first

Kill Text

ActiveSheet.SaveAs Filename:=Text, FileFormat:=xlTextMSDOS