No, you are not using low level file io as I suggested if you are opening it
in excel and experiencing the problem you describe. CSV is just a format
and it sounds like you file is already a CSV file even if it has a text
extension. You just want to take the extra commas off the end. Then you
should read the articles I provided and you will be able to do it and then
rename the file with the .CSV extension.


If you want to open it with excel as you currently are, then you can restore
the double quotes by looking at the code in this article.

http://support.microsoft.com/default...b;en-us;291296
Procedure to export a text file with both comma and quote delimiters in
Excel

--
Regards,
Tom Ogilvy


"LJi" wrote in message
oups.com...
Hi Tom,

Thank you for your quick reply.

Yes, that is what i was trying to do. I use fileio to strip out the
extra columns, but the file will be txt file instead of CSV. The next
step for user to upload the files into another system, they have to be
in CSV format. If i save the txt file into a CSV format from macro,
then reveiw it from notepad, the quotes gone. the only way i can keep
the quotes is open the txt file, manually save it as a CSV format. But
i can't find a way in macro to do so which user doesn't like it. they
want the macro handle everything until the end.

Any thoughts?