Good practices for internationalization?

[lord_yo]

Hi everyone

I am working on an excel tool which will support German and French users. I want to avoid having to set up all the sheets in two language versions, so I'm looking for good practices to switch languages by other means.

For example, I could imagine having a sheet with all static cell texts, button titles, msgbox contents, where German and French are two corresponding columns. I could either refer to specific entries or having a generic search & replace function when switching language.

What can you recommend as tried-and-true approaches for such a situation?
Are there any templates available for this?

 

[James006]

Hi,

You can get a very good starting point thanks to Ron

International Excel Issues

HTH

 

[lord_yo]

Hi,

You can get a very good starting point thanks to Ron

International Excel Issues

HTH

Thank you. Please note that different Excel language versions are not an issue here. What I am looking for is good approaches to switch the language of titles, static cell contents, button captions etc.

 

[James006]

Hi,

Stephen Bullen's book has a great chapter about the International Issues

Office Automation Ltd. - Excel 2002 VBA Programmer's Reference, Chapter 22

HTH