how do I stop warnings when saving .xls as csv?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to save an Excel file as a csv file on a reasonable regular basis can
I turn the warnings as I seem to be saving twice at least during the close
operation.
 
Hi
in VBA you could use
application.displayalerts=false
'your save code
application.displayalerts=true
 
You must log in or register to reply here.

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

Excel CSV Files; Creating Of 3
Excel And Notepad 3
how do I change a csv extension file to an xls file and use it? 1
.csv Commas ? 2
.XLS to .CSV files 1
Saving as CSV File 2
Annoying problem saving sheet w/macros as CSV 11
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1

Back
Top