View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Minitman[_4_] Minitman[_4_] is offline
external usenet poster
 
Posts: 273
Default Selecting A Printer With VBA

Greetings,

I need to have a form printed on the same printer regardless of which
work station is trying to print it. I have 5 work stations in my LAN
each with it's own printer. Only one of these printers can print the
entire form and the print process is initiated by CommandButton1 on
sheet1 at any of the 5 work stations.

Does anyone know how to get VBA to select the correct printer when
this button is clicked?

Any help would be appreciated.

TIA

-Minitman