Two questions about saving CSV file

A

amcom

I am trying to save a file in CSV format by calling SaveAs, using Excel
automation. But got two issues (maybe one)

1) If the CSV file exists, a message box pops up, "the file exists, do you
want to replace it?". I don't want this message box and want to overwrite it
anyway.
2) Even I answer "Yes" in last question, if I exit my automation program,
another message box pops up, "do you want to save the change you made to the
csv file?". I don't want this message box neither.

So is there anyway to finish this automation in a "silent mode" without
these message box showing up? Any suggestions? Thanks a lot.
 

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

Adding data to MS Access from csv file 0
Save workbook without shapes 0
Active Content in this file is blocked issue 1
Automation of scanned file storage based on content 0
How To Compare Two Csv Files Mainly Two Columns Containing Time 0
Create a dynamic master file 1
macOS Office365 Word 0
Excel And Notepad 3

Top