Save .txt file to .csv in VBA

Thanks for your reply.

I can finish the steps to create a txt file with quotes around each
fields. But eventually user needs each file with the extension .csv. So
I tried to open .txt from Excel then save it to .csv, however, if user
view the .csv file with notepad, all quotes are gone. But if i open the
..txt file from notepad, then do a saveas to a .csv format, then review
the new .csv file from notepad, i got the result user wants to see -
quotes with each filed. for example,

"Name", "Street", "City", "State",

But how can i make this a macro step for user?

Please help.

Thanks.

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

<[email protected]> wrote in message
news:[email protected]...
> Thanks for your reply.
>
> I can finish the steps to create a txt file with quotes around each
> fields. But eventually user needs each file with the extension .csv. So
> I tried to open .txt from Excel then save it to .csv, however, if user
> view the .csv file with notepad, all quotes are gone. But if i open the
> .txt file from notepad, then do a saveas to a .csv format, then review
> the new .csv file from notepad, i got the result user wants to see -
> quotes with each filed. for example,
>
> "Name", "Street", "City", "State",
>
> But how can i make this a macro step for user?
>
> Please help.
>
> Thanks.
>