Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I am executing the following prrocedure which is located in a standard module to get Adobe PDF to generate a postscript file. When I call this procedure from a worksheet module it executes perfectly. When I call it from a userform module, it crashes with the error "When you create a postscript file, you must rely on System fonts and use document fonts" and creates an empty postscript file. It should be calling the same print driver in both cases, but apparently is not. Does anyone know how to correct this? Am I missing a qualifier? Sub Printworkbookpdf() Dim myprinter As String myprinter=Application.ActivePrinter Worksheets("Cover").Select ActiveSheet.PrintOut Preview:=False, ActivePrinter:="Adobe PDF", PrintToFile:=True, PrToFileName:=psFileName Application.ActivePrinter=myprinter End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Available Printer names to be placed in a range on a sheet and Force selection based on part of Printer name | Excel Programming | |||
store default printer, change printer and then restore default printer? | Excel Programming | |||
members on my network printer not able to print to default printer | Excel Discussion (Misc queries) | |||
Printer Multiple Worksheets with a particular Printer Setting | Excel Worksheet Functions | |||
Send printer escape commands to a printer using VBA | Excel Programming |