Programatically Export to CSV

[mciavolino]

I need to be able to, via a macro, write out a CSV file without going through the dialogue boxes and all the warning dialogues (and without changing the open file).

Any ideas?

 

[KenCriss]

Welcome.

Look on this page for csv.zip. I think it will give you what you want.
http://www.xl-logic.com/pages/vba.html

 

[mciavolino]

Perfect. Thanks!