Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing to pdf
I am using Excel 2007 and have this code to print a document to pdf using Nitro Professional 7 and then reseting the workbook to the default printer Sub PrintPersonalPdf() Dim strPName As String strPName = Application.ActivePrinter Application.ActivePrinter = "Nitro PDF Creator 2 on Ne08:" Application.Run "PrintPersonalFax" Application.ActivePrinter = strPName End Sub The problem I have is that as soon as I removed my laptop from my network the code did not work. On checking it i found that the pdf printer had changed to "Nitro PDF Creator 2 on Ne04:" . Does the Ne04 refer to the port being used? This workbook is used on a number of different computers where I do not know the default printer or even if they have Nitro Professional installed. Is there some way to check if Nitro is installed and then set my code to the correct setting for the pdf printer as set on that computer? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Double-sided printing and printing entire workbook in one go. Macro to help ... ?? | Excel Programming | |||
Excel 2003 printing problem--printing 1 document on 2 pages | Excel Discussion (Misc queries) | |||
Excel Printing --Borders are not printing on the same page as data | Excel Discussion (Misc queries) | |||
Enable Double sided printing contiuously when printing multiple s. | Excel Discussion (Misc queries) | |||
Printing? Worksheets not printing the same on multiple pc's! | Excel Programming |