ExcelBanter - Save as CSV without being prompted

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Save as CSV without being prompted (https://www.excelbanter.com/excel-programming/271977-re-save-csv-without-being-prompted.html)

Tom Ogilvy

Save as CSV without being prompted

ActiveWorkbook.Close SaveChanges:=True

Regards,
Tom Ogilvy

Tod wrote in message
...
Could someone tell me how my code can make changes in a
CSV file and close it, saving changes, without being
prompted with the Save As dialog box?
Application.DisplayAlerts = False does not work.

tod

All times are GMT +1. The time now is 12:10 AM.