View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default delimiter sign in csv files

I think you'll have to take control over how you export the data if you really
want to ignore that windows setting.

Here are three sites that you could steal some code from:

Earl Kiosterud's Text Write program:
www.smokeylake.com/excel
(or directly: http://www.smokeylake.com/excel/text_write_program.htm)

Chip Pearson's:
http://www.cpearson.com/excel/imptext.htm

J.E. McGimpsey's:
http://www.mcgimpsey.com/excel/textfiles.html

Earl's program may work right out of the box.

shark102 wrote:

hello

when I save as csv columns get separated with commas. what do i need to do
to force';' - semicolon as delimiter sign regardless of computers regional
settings?

thanks


--

Dave Peterson