Print to specific printer -- macro

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
 
P

Per Jessen

Hi

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

Hopes this helps.
....
Per
 
T

tcebob

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

Top