Diniz
01-11-2012, 06:24 AM
I want a macro that makes it possible to choose automaticly the printer and the saved settings of the paper output. Choosing the printer works fine, but i dont know how to produce the code so i can print from saved settings.
This works fine:
Public Sub Print()
Application.ActivePrinter = "PRT2259 on srv0077:"
ActiveSheet.PrintOut Copies:=1
ActiveSheet.PrintOut
End Sub
But i dont know yet the code to print with the prefenced setting like "Iconletter." Maybe its something like:
Application.ActivePrinter.DeviceName = "Iconletter"
This works fine:
Public Sub Print()
Application.ActivePrinter = "PRT2259 on srv0077:"
ActiveSheet.PrintOut Copies:=1
ActiveSheet.PrintOut
End Sub
But i dont know yet the code to print with the prefenced setting like "Iconletter." Maybe its something like:
Application.ActivePrinter.DeviceName = "Iconletter"