Print to specific printer -- macro

  • Thread starter Thread starter tcebob
  • Start date Start date
T

tcebob

I tried to record a macro to print to a specific printer, but this is all I got:

Sub PrintToBullzipPDF()
'
' PrintToBullzipPDF Macro
' Macro recorded 5/10/2010 by Robert Shiffman
'

'
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
End Sub

How can I name the printer in the macro?

rs
 
Hi

With the macro recorder on, change from default printer to PDF printer and
back.

Hopes this helps.
....
Per
 
Worked fine. Thank you Per.

rs

: Hi
:
: With the macro recorder on, change from default printer to PDF printer and
: back.
:
: Hopes this helps.
: ...
: Per
:
: "tcebob" <handle @ gwi.net> skrev i meddelelsen
: : > I tried to record a macro to print to a specific printer, but this is all
: > I got:
: >
: > Sub PrintToBullzipPDF()
: > '
: > ' PrintToBullzipPDF Macro
: > ' Macro recorded 5/10/2010 by Robert Shiffman
: > '
: >
: > '
: > ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
: > End Sub
: >
: > How can I name the printer in the macro?
: >
: > rs
: >
: >
 
Back
Top