I'm using VBA and xl2002. I have Elements 6.0 installed. I have some
information on "printing" to a PDF file, but at the moment I'm stumped in
just what I should set the Application.ActivePrinter to. Looking on the web
I find a variety of possibilities. Everything needs to be done with VBA.

Don <www.donwiss.com (e-mail link at home page bottom).

Don,
Record a macro whilst you change the printer, to get something like:
Application.ActivePrinter = "Adobe PDF on Ne02:"
However, this code may not be portable, as you cannot be sure the printer is
connected to the same port. Tom has a solution:
http://groups.google.co.uk/group/mic...9c671f b0bd75

Failing that, look for classes that provide VBA with the functionality of
VB's printers collection.

NickHK

"Don Wiss" wrote in message
...
I'm using VBA and xl2002. I have Elements 6.0 installed. I have some
information on "printing" to a PDF file, but at the moment I'm stumped in
just what I should set the Application.ActivePrinter to. Looking on the
web
I find a variety of possibilities. Everything needs to be done with VBA.

Don <www.donwiss.com (e-mail link at home page bottom).