Save Excel Worksheet As CSV - No Save As Dialog
 

I need to save an Excel worksheet as a CSV file using VBA without any prompts
or dialogs. Using the .SaveAs method, however, leads to a prompt:

"Do you want to save the changes you made to filename.csv?"

I don't get this prompt if I save the file as an .xls (due to
SaveChanges=False / DisplayAlerts=False/...). Can this be done to csv files
without resorting to OLE commands, etc.?

Any help/suggestions greatly appreciated.

SQLServant

Save Excel Worksheet As CSV - No Save As Dialog
 

Found an answer a few seconds after posting this questions (don't u hate it
when that happens?).....

I used the .Saved=True method just before closing the newly created csv
file. This stopped the prompt.

SQLServant



"SQLServant" wrote:

I need to save an Excel worksheet as a CSV file using VBA without any prompts
or dialogs. Using the .SaveAs method, however, leads to a prompt:

"Do you want to save the changes you made to filename.csv?"

I don't get this prompt if I save the file as an .xls (due to
SaveChanges=False / DisplayAlerts=False/...). Can this be done to csv files
without resorting to OLE commands, etc.?

Any help/suggestions greatly appreciated.

SQLServant