microsoft.public.word.vba.general

That problem is most likely caused by the need to replace commas with
semi-colons in some instances, where the comma is acting as a list
separator.

In the Control Panel>Regional and Language Options, if you click on the
Customize button on the Regional Options tab, you can change the list
separator back to a comma. Of course, that will only be good for the
machine on which you change it and won't help if you are distributing the
code to other users.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Bear" wrote in message
news:13C8FF34-D538-48F5-869D-FF1B8BDE5CFC@microsoft.com...
> Does anyone have any tips or links to information about localizing my VBA
> code? So far it's been running in North America and Australia, where some
> form of English can be selected from the Regional Options, and where an
> English keyboard is in use.
>
> Now I'm going into Spain, and aside from a different keyboard layout, some
> macros seem to stumble. Here's the most common error message:
>
> The Find What text contains a Pattern Match expression which is not valid.
>
> I'm also wondering how I should handle the different delimiters used in
> numbers (decimals vs. commas). Date formats aren't a big problem yet.
>
> Can I detect the language settings in VBA?
>
> Bear
>
> --
> Windows XP, Word 2000