Save Excel Worksheet As CSV - No Save As Dialog

G

Guest

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Save All Worksheets as CSV 7
Looping Open and Save as CSV 9
Closing workbook open as CSV 3
copy and save as csv 4
Command Button to export a worksheet as a .csv file 1
'Save as' dialog opens despite Application.DisplayAlerts = False 6
How to export excel sheet to CSV 1
Save Excel file to a CSV without opening it first 4

Top