Sending print output to PDF file?

[Don Wiss]

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).

 

[NickHK]

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/mi...0bd75?lnk=st&q=&rnum=1&hl=en#ec029c671fb0bd75

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

NickHK