Print buttons or print command buttons

[Artisez]

Good morning,

I am somewhat a rookie with VBA, etc. Where I work I have to complete spreadsheets and print them to different printers at different locations at my job site. I familiar with creating buttons or command buttons with simple codes. But I was wondering if any one could help with a code that would allow me to print a spreadsheet to specific printers at different locations? Any help would be appreciated.


▬▬▬▬▬▬▬▬▬ Mod edit : thread moved to appropriate forum !

​

 

[Marc L]

Hi !

Just activate the Macro Recorder and change manually the driver
for a printer : you will get your code …
​

 

[Artisez]

Thanks, will give it a try at work in the morning.

 

[Logit]

Paste in a Routine Module :

Option Explicit

Sub commandbutton1_click()
    Application.Dialogs(xlDialogPrint).Show
End Sub

 

[Artisez]

I attempted to record a macros, however if I only do one button it works. Adding additional buttons it will only print to the last printer added. I am trying to add 3 buttons to print to three separate printers individually. I attempted another method and I print to all printers at once.

 

[Artisez]

Paste in a Routine Module :

Option Explicit

Sub commandbutton1_click()
    Application.Dialogs(xlDialogPrint).Show
End Sub

Unfortunately I cannot get this to work...yet.

 

[Artisez]

I attempted to record a macros, however if I only do one button it works. Adding additional buttons it will only print to the last printer added. I am trying to add 3 buttons to print to three separate printers individually. I attempted another method and I print to all printers at once.

GOT IT TO WORK, Thank you.

 

[Logit]

You are welcome