Printer selectiom bij macro / vba

[swingleft]

Hello, ( i'm new here)

Dutch site for excel questions is lo longer on the air / active.

----------------------------------------------------------------------
I'm using a "print selection" button on a sheet.

problem is, i first need to select the correct printer.

is there a way to do this automaticly

Thanks in advance for all the help.

gr.

Swingleft

[Greg M]

Hi there,

problem is, i first need to select the correct printer

Problem is, WE need to know what IS "the correct printer"

Can you give us a bit more information?

Regards,

Greg M

[swingleft]

Hi,

there are about 6 printers installed on the pc,

For printing tab 1 i use the default printer

But for printing tab 2 i need to print labels on a dymo printer.

therefore i first need to change te active printer to Dymo.

i tried to record a macro where i changed the printer selection, but nothing was recorded.

[jolivanes]

How to get all printers and printer ports.
http://www.experts-exchange.com/Soft..._27566782.html

How to implement.
https://www.safaribooksonline.com/li...7663/re02.html

or

Please Login or Register  to view this content.

Hopelijk werkt een van deze. (I hope one of these will work for you)