Hello,
I have a "Print Form" command button on an excel vba form. I am trying to send the form to a printer other than the default printer using:
Application.ActivePrinter = "HP LaserJet 8000 Series PCL on LPT4:"
NewSparePart.PrintForm
The problem is that the .PrintForm method ignores the setting of the ActivePrinter and prints to the default printer.
Can anyone please offer any suggestions? Thank you.