Results 1 to 3 of 3
  1. #1
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts

    VB constant for separator (Excel 2003)

    I spent a happy hour this morning using NetMeeting to control the PC of a Russian colleague, trying to understand why my code wasn't working. It turns out that I was inserting an Excel formula that included AND(something, somethingelse) and the use of the comma is a regional setting, on his PC the correct syntax was AND(something; somethingelse).

    I am sure that there is a VB constant that I can use to insert the <big><big>,</big></big> or <big><big>;</big></big> depending on regional settings, but I can't remember what it is and I haven't managed the correct incantation for finding it on my favourite search engine.

    Does anyone remember?

    StuartR

  2. #2
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts

    Re: VB constant for separator (Excel 2003)

    I found it, just in case anyone else stumbles on this post in the future it is
    <code>Application.International(xlListSeparator) </code>

    StuartR

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VB constant for separator (Excel 2003)

    >I found it, just in case anyone else stumbles on this post in the future it is

    International.
    Thanks!
    Handy set of standard constants.

    In Word97:
    <pre>Application.International(wdListSeparator)</pre>


Posting Permissions

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