Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello out there
I'm using the following code from Ken Puls (thanks Ken) which works fantastically well. However, I note that a pdf created by PrimoPDF is only 2/3 of the size, and just as sharp when printed. Does anyone know what reference library to use so I can use Primo in the same code? There doesn't seem to be anything that works when I add it from the Primo folder. I'll bet Dave Petersen knows! Regards, Brett Option Explicit Sub PrintToPDF_Early() Dim pdfjob As PDFCreator.clsPDFCreator Dim sPDFName As String Dim sPDFPath As String 'OUTPUT FILE NAME sPDFName = Range("pdf.name").Value sPDFPath = ActiveWorkbook.Path & Application.PathSeparator If IsEmpty(ActiveSheet.UsedRange) Then Exit Sub Set pdfjob = New PDFCreator.clsPDFCreator With pdfjob If .cStart("/NoProcessingAtStartup") = False Then MsgBox "Can't initialize PDFCreator.", vbCritical + _ vbOKOnly, "PrtPDFCreator" Exit Sub End If .cOption("UseAutosave") = 1 .cOption("UseAutosaveDirectory") = 1 .cOption("AutosaveDirectory") = sPDFPath .cOption("AutosaveFilename") = sPDFName .cOption("AutosaveFormat") = 0 .cClearCache End With ActiveSheet.PrintOut Copies:=1, ActivePrinter:="PDFCreator" Do Until pdfjob.cCountOfPrintjobs = 1 DoEvents Loop pdfjob.cPrinterStop = False Do Until pdfjob.cCountOfPrintjobs = 0 DoEvents Loop pdfjob.cClose Set pdfjob = Nothing End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Automatic Quote Number Creator | Excel Worksheet Functions | |||
Free pdf creator which can render hyperlinks? | Excel Worksheet Functions | |||
How can I determine the original creator of a spreadsheet? | Excel Worksheet Functions | |||
NACHA FILE CREATOR | Excel Discussion (Misc queries) | |||
How do you copy a cell's content verses it's formula? | Excel Discussion (Misc queries) |