OK, here I am.
Please download the modified Excel file from here (Wikisend is having problems at the moment):http://ge.tt/9bZMZQT/v/0?c
The file is zipped with password "1234
" since some servers filter out files with macros.
I added Module1 with code for the SetPrinterDuplex sub and added appropriate calls to Print_Data macro, like this one:SetPrinterDuplex Printer.DeviceName, 3 'AAATom
It took me a bit longer because I was testing the code. The thing is, at this PC I have only Excel2003 which cannot run all the statements in the macro. I do
have Excel2007 at home but will not be able to test it sooner than some 4 hours from now.
So, please test if the code works as expected.
The SetPrinterDuplex macro pops up message boxes if it encounters problems - write them down (or just look in the code) and let me know which ones popped up (if any).
If there are any problems, I'll try to sort them out when I get home to my PC.