how to call for printer function

[chubbychub]

I have a printer, and finally figured out that it changes on the name, so its named like this:

Canon on NE01:
Canon on NE02:
Canon on NE04:
Canon on NE05:
and so forth
after searching it came up to something that works on dynamic names of printers from this link: https://www.excelforum.com/excel-pro...numbering.html

If someone that can help me write the sub to print on whatever the printer name is to print the below sheets:

Please Login or Register  to view this content.

i dont know how to call for functions, and just started reading about functions, unsure how to use it yet. If someone would kindly moc up a simple example of this please
Arkadi in post #30 on that link, if someone that can merged it to print out sheet4 please

[ByteMarks]

That function will work
Put it in a standard module.

Please Login or Register  to view this content.

Then call it from your print routine, e.g.
I've highlighted the function line. Replace "Microsoft Print to PDF" with the full name of your printer as displayed in file/print

Please Login or Register  to view this content.

[chubbychub]

thank you Bytemarks for the reply, its sending to the wrong printer, the Printer name changes depeding on which computer, the name of the printer is "Canon on NE01:" "Canon on NE02:", "Canon on NE03" and so forth, depeding on the computer that the macro runs, so can the code in that link from arkadi post #30 be linked to Leith Ross code can be call to search for the printer name and call for it?
i want tocall for this function before it prints :

Please Login or Register  to view this content.

[ByteMarks]

The on NE01: part is port and is provided by the function which retrieves it from the registry
So if the name of the printer is "Canon" you could try

Please Login or Register  to view this content.

[chubbychub]

Bytemarks! thank you! i was trying to figure out how your code works and how it was calling for port number NE0x.. but your code but it loops thru all the printers and just matches what its call from the computer which is great! its better than what i was expecting!. you the best and thank you again! no one answered or replied but you.