How to disable the numerous pop-up/warning boxes when saving as a .csv file?

[pcvchriskmg]

Hi,

I am using Excel 2007. I am editing and re-uploading a .csv file, and each time I save my file, I am confronted with the following messages:

"Filename" may contain features that are not compatible with CSV (comma delimited). Do you want to keep the workbook in this format?

I click "Yes" and then receive:

Then when I go to close the file, immediately after saving, I receive:

"Do you want to save the changes to "Filename"?

I click "Yes" and the receive, again:

"Filename" may contain features that are not compatible with CSV (comma delimited). Do you want to keep the workbook in this format?

I just want to save and close the file without these warnings. How can I disable them?

Thanks,
Chris

 

[Trevor G]

Try using:

Sub ***()
Application.ScreenUpdating = False
Application.DisplayAlerts = False

'After the other code switch back on
Application.DisplayAlerts = True
Application.ScreenUpdating = True

End Sub

 

[pcvchriskmg]

Try using:

Hmm,

I'm still getting it.

I did not try it with any other format tha .csv though.

Chris