How to set Excel’s ActivePrinter using VBA?

Changing Excel’s ActivePrinter using VBA isn’t as straightforward as you might think. In particular there is a localization issue.