VBA code for stopping the save promt box from poping up

[HeyHey89]

I am running a VBA code to convert several excel files and I am needing to get the pop up prompt to stop showing. This is the code I am working with

Application.DisplayAlerts = False

ActiveWorkbook.SaveAs Filename:"E\bob_smith\Done.txt" FileFormat:=xlText

Application.DisplayAlerts = True

I have tried

1. ActiveWorkbook.SaveAs Filename:"E\bob_smith\Done.txt" FileFormat:=xlText = True ​

2. Application.EnableEvents= False

3. Application.ScreenUpdating= False

 

[JLGWhiz]

If the message is popping up when you close a workbook that you have just done the SaveAs on then this syntax would prevent the alert message.

ActiveWorkbook.Close False

It tells Excel that you do not want to save the workbook again. If you do want to save it again then use True as a parameter.