Menu

Excel VBA/macro problem; Export to csv

Search this Thread

Prev

Previous Post

Next Post

Next

#2

Report Post

Posted to microsoft.public.excel.programming

JE McGimpsey JE McGimpsey is offline

JE McGimpsey is offline

external usenet poster

Posts: 4,624

Default

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/

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
excel export Macro that does a filter	Jerome_Ball	Excel Discussion (Misc queries)	1	August 6th 08 03:17 PM
excel xml export macro	Dan	Excel Discussion (Misc queries)	0	March 19th 08 03:16 PM
export to excel option - problem	[email protected]	Excel Discussion (Misc queries)	1	July 25th 07 07:20 AM
Export Excel Data to Access With a Macro!!!	Jac	Excel Discussion (Misc queries)	3	December 28th 04 07:39 PM
Export Excel data to Access Security problem	Annelie[_3_]	Excel Programming	5	December 30th 03 11:14 PM

All times are GMT +1. The time now is 12:05 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement