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
: >
: >
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top