VBA in other countries

[uecem]

Hi,

I have put together a spreadsheet which has a number of fuctions lik
vlookups and countif's and also a few Macro's.

I've now been told that this spreadsheet may be used in othe
countries. Does anyone know if there will be any problems with thi
since functions in other countries generally use that other countrie
language settings?

Will the code work just the same?

Thanks

E

 

[Juan Pablo González]

There are some quircks, not that many, that you may face, but it all depends
too on how your code looks. The best reference for 'International issues'
as it's known is in "Excel 2002 VBA" by Bullen, Green, Bovey and Rosenberg.
Great book.

 

[Frank Kabel]

Hi
normally you should have no problems. Some things that may cause
problems:
- dealing with boolean values (e.g. FALSE vs. FALSCH -> German)
- Date processing / different date formats
- using then .formulalocal property
- hardcoding the 'coma' as list delimter

You may have a look at application.international for making parts of
your code more generic

 

[keepITcool]

in general.. there should be no problems.

avoid using functions from the analysis toolpack or other addins.
these DO NOT translate!

re VBA:

avoid using the properties/methods which are typically for localized use
like .FormulaLocal

Most international issues are solely concerned with international
separators (decimal, list and date) and you should test for that.

Just set your machine to use German country settings from control panel.
then run your macro's. I'm Dutch myself, but found that using German is
very effective for testing... as it uses some STRANGE things like . as
date separator.

If the workbook is protected and to be used in France, that might
be a problem. Check MSKB)


of course there are exceptions to every "general rule"

... find an "excel savvy" user in one of the countries
and have him or her test it on a local excel version.



keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >

 

[Frank Kabel]

Hi keepitcool

[...]

Just set your machine to use German country settings from control
panel. then run your macro's. I'm Dutch myself, but found that using
German is very effective for testing... as it uses some STRANGE
things like . as date separator.

why is that strange <vbg>. For me using '/' is very strange
But I agree with you. Using English and a 'EU continental' language
should help to identify most of the issues.



Frank

 

[keepITcool]

<g>

But I do love the fact that German Excel uses ROUND brackets
in z(1)s(-3) references. Those have given me some real headaches!

No hard feelings. Unless I remember 1974.




keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >

Hi keepitcool

[...]

Just set your machine to use German country settings from control
panel. then run your macro's. I'm Dutch myself, but found that using
German is very effective for testing... as it uses some STRANGE things
like . as date separator.

why is that strange <vbg>. For me using '/' is very strange
But I agree with you. Using English and a 'EU continental' language
should help to identify most of the issues.



Frank

 

[Juan Pablo González]

In Spanish Excel is the same thing:

=F(-1)C(-1)

--
Regards

Juan Pablo González

<g>

But I do love the fact that German Excel uses ROUND brackets
in z(1)s(-3) references. Those have given me some real headaches!

No hard feelings. Unless I remember 1974.




keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >

Hi keepitcool

[...]

Just set your machine to use German country settings from control
panel. then run your macro's. I'm Dutch myself, but found that using
German is very effective for testing... as it uses some STRANGE things
like . as date separator.

why is that strange <vbg>. For me using '/' is very strange
But I agree with you. Using English and a 'EU continental' language
should help to identify most of the issues.



Frank