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?