VB constant for separator (Excel 2003)

Topic

New Reply

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 , or ; 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

Reply | Quote

Replies

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

StuartR

Reply | Quote

>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:

Application.International(wdListSeparator)

Reply | Quote