2005-12-14, 09:54 AM
Hi there Mixman,
I've just completed the macro. It creates a language.xml file in unicode. So this fixes the problems you had with translating Arabic and Hebrew. I does not seem to work well with Korean though. And I noticed that many translations are longer than the original text so they don't fit (at work we change the gui accordingly, but that is really quit a lot of work so sub may not want to do that. Also some translations are just way too long anyway).
But first the macro:
- I asume I don't have the most up to date excel sheet so I just added the code.
- Open the excel sheet
- Select main menu extra\macro\visual basic editor
- Selectc Insert new module (not a class module! choose any name you like)
- Paste the code I suplied
- save and close VB editor
- select main menu extra\macro\run
- You should get the option: CreateSingleXml()
- run it
Note: You probably have to lower the security settings and even close and reopen Excel.
I've just completed the macro. It creates a language.xml file in unicode. So this fixes the problems you had with translating Arabic and Hebrew. I does not seem to work well with Korean though. And I noticed that many translations are longer than the original text so they don't fit (at work we change the gui accordingly, but that is really quit a lot of work so sub may not want to do that. Also some translations are just way too long anyway).
But first the macro:
- I asume I don't have the most up to date excel sheet so I just added the code.
- Open the excel sheet
- Select main menu extra\macro\visual basic editor
- Selectc Insert new module (not a class module! choose any name you like)
- Paste the code I suplied
- save and close VB editor
- select main menu extra\macro\run
- You should get the option: CreateSingleXml()
- run it
Note: You probably have to lower the security settings and even close and reopen Excel.