ExcelBanter

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/271967-re-save-csv-without-being-prompted.html)

Randall Arnold[_2_]

Save as CSV without being prompted
 
I believe you can use something like ThisWorkbook.Saved = True.

Randall Arnold

"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 07:35 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com