I've created a template in English. Now I need to create an identical one in French (Canadian). How do I change the language in the VB script to show - for example - the dates in French?
This is the code I'm using and even though I set the default language in the template to French Canadian, the date October shows up rather than Octobre.
frmXXX.TextBox1.Text = "Le " & Format(VBA.Date, "dd Mmmm, yyyy")
As always, many thanks in advance experts :)