ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel VBA/macro problem; Export to csv (https://www.excelbanter.com/excel-programming/302729-excel-vba-macro-problem%3B-export-csv.html)

[email protected]

Excel VBA/macro problem; Export to csv
 
This is my problem:

I'm trying to save my data into csv file with a simple macro I hav
created.

For example my csv (semicolon delimited) file should look like this:

A;B;C
1;2;3
0,1;0,2;0,3

But I'm getting:

A;B;C
1;2;3
"0,1";"0,2";"0,3"

Does anyone have a script for avoiding those " marks ? Or othe
tips...
Thanks
Vill

--
Message posted from http://www.ExcelForum.com


JE McGimpsey

Excel VBA/macro problem; Export to csv
 
See

http://www.mcgimpsey.com/excel/textf...ml#csvnoquotes

In article ,
wrote:

This is my problem:

I'm trying to save my data into csv file with a simple macro I have
created.

For example my csv (semicolon delimited) file should look like this:

A;B;C
1;2;3
0,1;0,2;0,3

But I'm getting:

A;B;C
1;2;3
"0,1";"0,2";"0,3"

Does anyone have a script for avoiding those " marks ? Or other
tips...
Thanks
Ville


---
Message posted from
http://www.ExcelForum.com/


All times are GMT +1. The time now is 06:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com