Does anyone know how to get any other printer properties besides the active
printer name in VBA?  I'm trying to select different paper trays depending on
which printer users are printing to, but only seem to be able to hardcode the
active printer names into the vba code.  This is OK, but if we change the
printer name at any time I will have to (firstly remember to) sift through my
code for every instance of the printer name! Not ideal - would be better if I
could read the driver name or model of printer?  Any ideas please?

Thanks
GwenP