Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Sep 2003
    Location
    Betekom, Belgium
    Posts
    88
    Thanks
    0
    Thanked 0 Times in 0 Posts

    csv behaviour (vba- excel 2000 vs 2002)

    hello,

    i just met a curious problem with a csv-output from excel.
    The macro saves a csv-file with the line "ActiveWorkbook.SaveAs Filename:=bestandb10, FileFormat:=xlCSV, CreateBackup:=False
    ActiveWorkbook.Close savechanges:=False"
    in excel 2000 this get us a file with ([img]/forums/images/smilies/wink.gif[/img] semi colon separators and in 2002 one with (,) colons separators we need semi colons but how is this possible form on pc vs another.
    Can someone be of assistance please ?

    Kind ragards,
    Jan

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: csv behaviour (vba- excel 2000 vs 2002)

    Do both PC's have different regional settings (point or comma as decimal separator)?
    If the regional settings are the same, do they have different settings in the International tab of Tools | Options... in Excel?

    (On my Dutch-language system, Excel 2002 creates CSV files with semi-colon ; as separator)

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: csv behaviour (vba- excel 2000 vs 2002)

    Check out this chapter about International issues of Stephen Bullen
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  4. #4
    Star Lounger
    Join Date
    Sep 2003
    Location
    Betekom, Belgium
    Posts
    88
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: csv behaviour (vba- excel 2000 vs 2002)

    hello Hans, jan karel,

    Your two answers combined made me write the save as as follows :
    ActiveWorkbook.SaveAs Filename:=bestandb10, FileFormat:=xlCSV, local:=True, CreateBackup:=False

    the local true gives a semi colon
    the local false gives as colon

    now i am curious on what it does with the others ones pc

    Interesting feature worth studying.
    Thanks,
    jan

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •