I recently came across
http://www.excelgaard.dk/Lib/PrinterDuplex/ while looking for something else. Here you will find a Windows.dll file that adds the functionality to determine and switch printer modes from VBA. I have added it here for completeness, should anyone else be searching for it later.