Need a macro to export data to a csv file

[dagwoodnil]

Hi,

I am not vary familiar with VB and have search the forum to no avail.

I have a spreadsheet that users will be entering data onto.
Once they are done, they will need to export the data to a csv file and drop it into a shared folder.

To make the task simple, I like to have a macro for the users to export the file.

The spreadsheet contains four columns with alpha numeric information.
The last column is a date value (yyyy-mm-dd)

The file should be exported with the following format:
- columns are separated by either '|' or comma
- if separated by comma, double quotes is require around each field.
- the file will be saved to a specific loacation (ie c:\temp\)
- the file name should be (filename_yyyymmdd_hh24miss)

Any help is greatly appreciated.

Nathan

[patel45]

attach please a sample file and desired csv

[dagwoodnil]

Hi Patel,

Sorry for such late response.
The expected output will look something like this.

Title A|Title B|Title C|Title D
123456789|A1234|1.234.234|2013-10-01
123456789|A1234|1.234.234|2013-10-01
123456789|A1234|1.234.234|2013-10-01

The file name would be like 'filename_yyyymmdd_hh24miss.txt'

Your help is greatly appreciated.

Nathan