Selecting printer

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using automation to have Excel create and print a PIVOT TABLE from an
Access application.

Everthng working fine. BUT how do I control printer selection to ensure the
correct printer is used?

Thanks for the help,
Lee
 
Additional info that I neglected to mention.

I have tried using
Application.Printer = Application.Printers("HP Color LJ 3700N PCL 6")
MsgBox Application.Printer.DeviceName 'Just to be sure it took
ActiveChart.PrintOut

I get the chart to print, but not on the color printer

I have even tried
xlApp.Application.Printer = XlApp.Application.Printers("HP Color LJ 3700N
PCL 6")
But the xlapp object will not accept this.

Any ideas?

Thanks,
lee
 
Back
Top