Problem with multilingual VBA Programming

  • Thread starter Thread starter Amol J
  • Start date Start date
A

Amol J

Hi Experts,

I have created a Excel model. Which is going to be used in various countries.

we are facing problem dealing with various languages. eg. While using my model in Germany its giving garbage output. because of language settings on German machine. They have office 2010 version with German language.


Please suggest me how to deal with such problem. Or is there any solution to deal with this issue
 
Amol said:
I have created a Excel model. Which is going to be used in various
countries.

we are facing problem dealing with various languages. eg. While using my
model in Germany its giving garbage output. because of language settings
on German machine. They have office 2010 version with German language.


Please suggest me how to deal with such problem. Or is there any
solution to deal with this issue
Click to expand...

There's always a solution. The question is, will any solution work for *you*?

Post your code. If you can, indicate where crashes are happening.
 
Hi Experts,

I have created a Excel model. Which is going to be used in various countries.

we are facing problem dealing with various languages. eg. While using my model in Germany its giving garbage output. because of language settings on German machine. They have office 2010 version with German language.
Click to expand...
What sort of garbage? The annoying things I have encountered are usually
a few important keywords used for indexing have local translated names
which can cause "not found" chaos if you use them.
Please suggest me how to deal with such problem. Or is there any solution to deal with this issue
Click to expand...

Avoid using keywords that are localised in international versions or if
you must use them have a list of keyword vs language(s) you support.
Various places offer tools for more complete localisation:

http://www.sobolsoft.com/excelenglishgerman/

(not a recommendation - never tried it)

If you gave a more specific example it would be possible to comment on
why it is going wrong. ISTR "Chart" and "Sheet" can get localised. So if
you create a new sheet it can end up being called something odd.
 
Amol said:
Hi Experts,

I have created a Excel model. Which is going to be used in various countries.

we are facing problem dealing with various languages. eg. While using my model in Germany its giving garbage output. because of language settings on German machine. They have office 2010 version with German language.


Please suggest me how to deal with such problem. Or is there any solution to deal with this issue
Click to expand...

Please post your code.
It is hard to say what does not work without that.
There are some minor problems with localized versions of office but 99%
of code works fine with them.
 
Back
Top