Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing PDF from Excel
I have a very simple macro that prints part of an Excel workbook to PDF, it
works fine on my computer but when someone else trys to use it, it errors out. The code is: Sub CC() ' ' Adobe Macro ' Macro recorded 4/7/2005 by kbrand ' ' Sheets(Array("CC", "CC_")).Select Application.ActivePrinter = "Adobe PDF on Ne01:" ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _ "Adobe PDF on Ne01:", Collate:=True Sheets("Input").Select End Sub The issue is my Adobe PDF is on Ne01 while everyone else's it Ne00, I have searched high and low looking for a solution. Hopefully somebody can help. Thanks, Kevin |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing PDF from Excel
Hi Kevin,
Is the Adobe printer named something else on the other users PC? Sunil Jayakumar "lance99" wrote in message ... I have a very simple macro that prints part of an Excel workbook to PDF, it works fine on my computer but when someone else trys to use it, it errors out. The code is: Sub CC() ' ' Adobe Macro ' Macro recorded 4/7/2005 by kbrand ' ' Sheets(Array("CC", "CC_")).Select Application.ActivePrinter = "Adobe PDF on Ne01:" ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _ "Adobe PDF on Ne01:", Collate:=True Sheets("Input").Select End Sub The issue is my Adobe PDF is on Ne01 while everyone else's it Ne00, I have searched high and low looking for a solution. Hopefully somebody can help. Thanks, Kevin www.ayyoo.com/car-loans.html |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing PDF from Excel
See if changing...
"Adobe PDF on Ne01:", to "Adobe PDF", works. HTH, Gary Brown "lance99" wrote: I have a very simple macro that prints part of an Excel workbook to PDF, it works fine on my computer but when someone else trys to use it, it errors out. The code is: Sub CC() ' ' Adobe Macro ' Macro recorded 4/7/2005 by kbrand ' ' Sheets(Array("CC", "CC_")).Select Application.ActivePrinter = "Adobe PDF on Ne01:" ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _ "Adobe PDF on Ne01:", Collate:=True Sheets("Input").Select End Sub The issue is my Adobe PDF is on Ne01 while everyone else's it Ne00, I have searched high and low looking for a solution. Hopefully somebody can help. Thanks, Kevin |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing PDF from Excel
Yes, it is named "Adobe PDF on Ne00:", I looked for a solution in the printer
port but couldn't find a solution. "Sunil Jayakumar" wrote: Hi Kevin, Is the Adobe printer named something else on the other users PC? Sunil Jayakumar "lance99" wrote in message ... I have a very simple macro that prints part of an Excel workbook to PDF, it works fine on my computer but when someone else trys to use it, it errors out. The code is: Sub CC() ' ' Adobe Macro ' Macro recorded 4/7/2005 by kbrand ' ' Sheets(Array("CC", "CC_")).Select Application.ActivePrinter = "Adobe PDF on Ne01:" ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _ "Adobe PDF on Ne01:", Collate:=True Sheets("Input").Select End Sub The issue is my Adobe PDF is on Ne01 while everyone else's it Ne00, I have searched high and low looking for a solution. Hopefully somebody can help. Thanks, Kevin www.ayyoo.com/car-loans.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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) | |||
Printing a heading on each new page when printing | 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 |