Save to a CSV with Double Quotes EXCEPT the Second Column with NO Quotes

[tkuy2k]

I don't know much coding but if I want to add quotes in first column and no quotes in second column what changes do I need to make in module listed below. I have tried few things but it doesn't seem to work. I will kee trying but any help you can provide will be appriciated.

Found this module in following post in this forum http://www.excelforum.com/excel-prog...no-quotes.html

Thanks in advance for your help

Please Login or Register  to view this content.

[patel45]

Please Login or Register  to view this content.

[HaHoBe]

Hi, patel45,

I ran into trouble with your code which didnīt feature the quotes for the first Column with my test file as well as did double up on the contents of Column B of the file - maybe you could attach yourīs to have a look at it.

Please Login or Register  to view this content.

Ciao,
Holger

[tkuy2k]

Thanks Patel45 and HaHoBe for your kind help.

I have one more question. I need to export this csv file as txt file and it seems to be working fine but it is adding Extra quotes when I save this as text file. Is there anything else that can remove these extra quotes when I save as text file.

Once again, thank you very much for your help.

[HaHoBe]

Hi, tkuy2k,

if you are using the extension txt instead of csv you should replace Write (for csv) with Print (for txt):

Please Login or Register  to view this content.

Ciao,
Holger

[tkuy2k]

This works. I am going to save a ton of time with this.
Thank you very much for helping me.