WinAPI within Excel 2003 Printer selector

HI all and thanks in advance for your time to read and hopefully
answer the quandry I'm in.

I have been trying to develop a macro that I can embed into a whole
bunch of existing Drawing register files. which have lists of upto 50
drawings per workbook within the spread***. What I need to be able
to do is find a way that will allow me to select via the Windows API
a
list of available printers. From this I will be using an if statement
to select the relevant printer dependant on the size of the drawing
to
be printed off. I will be mainly controlling adobe acrobat reader
and
DWF viewer. So my original paths of using the printto verb didn't
seem
to be working.


Many thanks in advance


David Armstrong

.

Quantcast