| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sending print output to PDF file?
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). |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Excel VBA: sending output data table to created .csv file +append Options | Excel Discussion (Misc queries) | |||
| How to keep the print output colour setting for the same file? | Excel Discussion (Misc queries) | |||
| Incorrect print output | Excel Discussion (Misc queries) | |||
| Open a print output sent to file | Excel Discussion (Misc queries) | |||
| How do I print from a file created from sending a print to a file | Excel Discussion (Misc queries) | |||
Threaded Mode
