Setting Duplex property on in Excel VBA

[alallen]

We are using a print macro in Excel 97 to print a large worksheet. We need to print the data duplex. How do you turn on Duplex on a HP5si. If we print duplex prior to running our print macro, it prints duplex. If we print single side, it prints single side. We have run a record macro, but nothing shows up in code that specifically turns on duplex printing.

Thanks.

 

[mel23]

Have you discovered any solutions to this problem since you last posted?

 

[alallen]

I have found a possible solution in a VBA Access book. I have not had time to try it in Excel yet, so officailly, I don't have a solution.

 

[mel23]

Please keep me posted on how it turns out if you try it. Thanks!