Excel VBA Print different sheet to different printer

[Arikrishnan S]

Dear Expert

Please help me for my below query

I want to print different work sheet to different printer example sheet1 to printer 1, sheet2 to printer 10, sheet3 to network printer.

 

[Hui]

Arikrishnan

Firstly, Welcome to the Chandoo.org Forums

I assume you want to do this via VBA

Simply turn on the macro recorder and print the 3 worksheets changing printers in between as required

The code should be self explanatory as the VBE does a good job with printers

 

[Arikrishnan S]

Dear Hui

Thanks for your mail

I have done that but the VBA code stops at selection.printout. I am using o365


The code is given below
Sub Macro1()
'
' Macro1 Macro
'

'
Range("B3:F16").Select
Selection.PrintOut Copies:=1, Collate:=True
End Sub

I google it but I could not get the way I wanted

 

[vletm]

@Arikrishnan S there are many instructions like this link:
http://www.exceltip.com/printing-in-vba/change-the-default-printer-using-vba-in-microsoft-excel.html

 

[Hui]

Simply add lines as appropriate

Application.ActivePrinter = "Local printer name" 'Local printer
'your code

Application.ActivePrinter = "HP4650" 'Local HP 4650 printer
'your code

Application.ActivePrinter = "\\WP0101\10.117.3.36" 'Network printer
'your code