printing help.

[isdex1]

What is the easiest way to assign a printer and print a file based on the first statement of the content of the file. Basically, I have setup 4 printers on my computer, I would like to print to a particualar printer based on a key word in the first sentence of the file content. Thanks.

 

[ZOR]

Have you done a keyword search here for Printers. There are a few threads that should help you. I saw one, there are probably more that give syntax for listing the printers on a system. You should therfore be able to suss the rest possibly. Regards

 

[TysonLPrice]

Here what I use to look for partial printer names. Maybe it willl help if you make "TPA" a variable out of the file:

Dim prn As Printer

  For Each prn In Printers
      If prn.DeviceName Like "*TPA*" Then
         Set Printer = prn
         Exit For
      End If
    Next

CR_CustomReport.SelectPrinter prn.DriverName, prn.DeviceName, prn.Port