Discussion Locked

Excel 97 & VBA

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I need to send from VBA the PCL 6 language of my printer so that I can tell my printer so to print duplex, Flip pages up, Watermark and so on. I have control when I show my xlprint dialog box, however when I show the properties box of the print driver all control is lost. anyone know how to maintain control over my print diver in code?

2 replies

by miss kitty

add a printer dialog box to your form and code it to activate when you execute your print command. By using a dialog box you can control what printer you want to send it to and you can go into the printer properties and change the settings without losing control.
Cathy

by shanghai sam

I want to be able to change the printer properties through code not through the user innerface. I can change the printer selection through code but not the printer properties. mabye a dll ocx, addin or something that would allow passing of printerproperties.

This discussion is closed to new replies.