PdfCreator 1.3.2 and order of pages

PDFCreator PDFCreator English
1

Hi.

I use PDFCreator printer to create PDF files by printing differents pages (differents "sheets") from Excel files with vb..

It worked fine with PDFCreator 1.2.x. and previous version.

Since the 1.3.2 version, pages in the PDF file created are - sometimes - in a different order than in the excel file.

For example :

- in excel, I send to the printer : page1, page2, page3, page4

- the resul in the PDF file can be : page2, page1, page4, page3.

The printer settings are exactly the same between PdfCreator 1.2.x and 1.3.2.

 

Any idea ?

Thanks

 

 

2

I quite the same. I need help ... please.

thanks

 

3

Solution here:

http://www.excelguru.ca/forums/showthread.php?139-PDFCreator-printing-pages-out-of-order

 

Add to code this:

 

'Print the document to PDF
    lTotlSheets = iShts - 1
    For lSheet = 1 To iShts - 1
        On Error Resume Next 'To deal with chart sheets
        If Not IsEmpty(Wbk.Sheets(lSheet).UsedRange) Then
            Wbk.Sheets(lSheet).PrintOut copies:=1, ActivePrinter:="PDFCreator"
           
'<-- Code added to check if sheet has entered queue before moving on
            'Wait until job has entered PDF queue
            Do Until pdfjob.cCountOfPrintjobs = lSheet
                DoEvents
            Loop
'-- Code modification ends -->
            
        Else
            lTotlSheets = lTotlSheets - 1
        End If
        On Error GoTo EarlyExit
    Next lSheet
 

 

4

I must add that it works well with PdfCreator 1.2.x with this setting : "Start printing after the last page is spooled". Otherwise it doesn't work.


Perhaps it's important to specify that the macro in excel is very fast, and can send 10 or 20 sheets to the printer in a few seconds.


 

5

Have software that produces a report over 3 or sometimes more pages - the first & second pages are not wanted. With the page order being mixed up and the all items having the same name this is difficult - would have to save all pages & delete the unwanted pages.

100's of these repoert are produced per month so this would be time wasting !

6

Hi All,

we have the same problem here with 1.3.2, we are printing access reports and then combine all which was working fine until the update.

Has anyone made any progress with this issue?

thanks,

Mick.

7

Hi,

 

this issue is most likely solved in version 1.4.0 which will be released in a few hours.

 

regards,

 

Robin

8

Great!

Thanks Robin, will test first thing tomorrow and report back, cheers.

Mick.

9

Tested this morning, no dice, still having the same problem.

It's like the report is being pushed to the printer and sometimes dissapearing and popping back at some other index(??).

Think I'll have to install an older version until this is solved, thanks.

10

Have you tested it with version 1.4.0?

11

Tested 1.4.0 this morning with 6 samples.

Worked - page order correct

Happiness

12

Thanks for the response.

13

Yes, test was with 1.4.0

thanks.

Mick.

14

Hi Mick,

 

a lot of people reported that the problem is solved.
Please uninstall PDFCreator, reboot and install 1.4.0 again and than test it please.

Best regards,