How to change the locale of a formatted date in Po

2019-09-05 17:59发布

问题:

in a powerpoint vba application I want to format a date according to the current spell-check language (which may or may not be the same as the system locale language).

e.g. Locale is German(Austria) but the document is in English for an english customer, hence the date format should be "1st January 2015" and not "01. Jänner 2015"

I found a solution for excel on this site: How to change the locale of a formatted date?

trying the same technique in powerpoint vba does not appear to work:

debug.print format (now(), "[$-415] MMMM")
 Jänner

debug.print format (now(), "[$-809] MMMM")
 Jänner

debug.print format (now(), "[any old rubbish] MMMM")
 Jänner

--> vba ignores whatever is in the square brackets.

Any suggestions how to achieve the same result within VBA?