Excel sheet Default Printer

[Jagat Pavasia]

dear sir,

I have 3 Printer attached with my PC.
1."Brother 7535-dw"
2."Brother 920DW"
3."Brother Label Printer Ql-810W"

Now, I Have a one excel file named "Label Print" , I want that when I open this file and automatically set default printer to "Brother Label Printer Ql-810W" and when I save and close file
and open another excel files then printer should remain default selection as it before. (My default printer is "Brother 7535-dw")

any VBA can help my question, please help me

 

[rollis13]

To solve your request, see if you can adapt the information you find here: LINK