Automatically Save External CSV-file

Hi,

I am using Excel 2007 on Windows 7.
I am trying to export data from a sheet in workbook to a separate csv-file on a predetermined location. However, I cannot seem to get the Macro to Auto-save the created file.
I have tried "DisplayAlerts = False" an "ThisWorkbook.Save". However they do not really match my criteria, since I am trying to auto-save an external file.

The code below creates a CSV an then writes the information to that file.

Here is the code I am working with: (source: http://www.mrexcel.com/forum/excel-q...orted-csv.html)

Please Login or Register  to view this content.

When running this, a get prompted to save the file manually. This is what I want to get rid of.

is there anyone out there with an idea of how to solve this?

Thank you!

Regards
Trf

Hi nathansav,
Yes, I would like to get around that prompt and make it auto-save the CSV to a specific location.

Regards

Worked perfectly! Thank you. I'm new to this.
Much appreciated.

Regards

I need to be able to export multiple .DAT files (csv file is converted) from one an the same excel file.

Regards