Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with multilingual VBA Programming
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with multilingual VBA Programming
Amol J wrote:
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 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. -- Microsoft MVP: Format |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with multilingual VBA Programming
On 07/02/2013 08:39, Amol J wrote:
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. 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 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. -- Regards, Martin Brown |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with multilingual VBA Programming
Amol J wrote:
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 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Programming problem | Excel Programming | |||
Table ranges do not work in multilingual configurations | Excel Programming | |||
Multilingual User Interface Pack for excel 2007 | Excel Discussion (Misc queries) | |||
Developing Multilingual VBA Apps | Excel Programming | |||
function names multilingual | Excel Programming |