Printing A Worksheet To Specific Printer Name
 

Hi..

I wonder if some one who could give me a bit of enlightenment.

I have 6 machines in a xp workgroup and have a document which i need to
place a print button and send page to different printers.

Each machine has had the printer drivers installed in no particular order so
the ports can be different but they are all networked using tcpip ports.. so
i cant hard code the printers in vba....

But all the names of the printers are numbered in there name all the same...
ie

01 Upstairs Printer
02 Colour Printer
03 ... etc

So I would like to do two things...

To read the list of printer and then match the printer number and send the
page to that ...
and then eventually have a print button which will load the list of printers
off the machine at runtime and give the user a way of selecting the printer
out the list..

Can ppl discuss the pro & cons and way of doing this...

Thanks

Nick