I develop quite complex Excel VBA application (several thousands lines of code spread across modules, class modules and form modules). There is a need to translate it to multiple languages, which means to replace (almost) all of the strings in application and use some kind of hash-table with records for each language.
My question is what is the most efficient and convenient way to gather all strings used in application and replace them with some kind of language variables. Could anybody recommend some kind of best practices for this type of task for VBA project environment? Thanks in advance.
string.Format
equivalent for VBA to have one string with placeholders instead of multiple fragments. Actually I did this 12 years ago for VBScript. Maybe this helps you further. - Uwe Keim