Roderick
09-08-2017, 04:01 AM
I have a client over in Canada who wants me to create one template to satisfy both Canadian English users as well as Canadian French users.
They are using Word 2016 and Windows 10. Funnily enough, so am I.
Now, I can create templates which read the Country and Format settings from the Region settings of the Control Panel (provided they are set correctly by the user!). I've done it for a bilingual English/Spanish template. However, the problem arises when working with Canada - the country is the same, but the languages can be different.
Is there anywhere in the Region area of the Control Panel settings that users can set their language, say Canadian(English) or Canadian (French) and VBA could read these settings and apply appropriate textual changes to the document, please?
What VBA would I have to employ to achieve this?
Could someone suggest ideas, please?
Thanks.
They are using Word 2016 and Windows 10. Funnily enough, so am I.
Now, I can create templates which read the Country and Format settings from the Region settings of the Control Panel (provided they are set correctly by the user!). I've done it for a bilingual English/Spanish template. However, the problem arises when working with Canada - the country is the same, but the languages can be different.
Is there anywhere in the Region area of the Control Panel settings that users can set their language, say Canadian(English) or Canadian (French) and VBA could read these settings and apply appropriate textual changes to the document, please?
What VBA would I have to employ to achieve this?
Could someone suggest ideas, please?
Thanks.