pdf24 creator vba printout problem

Home Forums PDF24 Creator General pdf24 creator vba printout problem

Tagged: 

This topic contains 6 replies, has 2 voices, and was last updated by  gggeorggge 1 week, 2 days ago.

Viewing 7 posts - 1 through 7 (of 7 total)
  • Author
    Posts
  • #5703

    gggeorggge
    Participant

    Hi all!

    I have some problem when i try to print excel file from vba on MS Windows Server 2012R2 with help of Pdf creator printer (I checked settings a lot times, PDFPrinter is default on server). On server i remotely start bat file that open excel with macro (i start task with help of regular user not system user).
    But on my laptop all works fine.
    I use the following vba code:
    ActiveWorkbook.Sheets(1).PrintOut
    or
    ActiveWorkbook.Sheets(1).PrintOut ActivePrinter:="PDF24 PDF on Ne00:"
    VBA code on server works without any errors. But pdf file is not generated in output directory.
    Where is source of problem?

    #5704

    gggeorggge
    Participant

    I am also try to print on server with cli with following command:
    pdf24-docTool.exe -shellPrint "YOUR_FILE"
    But no pdf file generated in output dir.

    #5705

    stefan
    Keymaster

    Is the printer configured to save automatically? How is you configuration actually? What do you try to do?

    #5707

    gggeorggge
    Participant

    Why when i try convert excel to pdf with help of following command "pdf24-DocTool.exe -shellprint "C:\KRO61061.xlsm", excel ask me about save excel file?

    #5708

    stefan
    Keymaster

    The shellprint command just uses the ShellExecute Function from the Windows API with the "print" operation. What follows than is not up to PDF24.

    #5709

    gggeorggge
    Participant

    Ok. Thank you.
    Another question.
    Why when i use following code from excel vba on server:
    ActiveWorkbook.Sheets(1).PrintOut
    or
    ActiveWorkbook.Sheets(1).PrintOut ActivePrinter:="PDF24 PDF on Ne00:"
    PDF file sometimes is not generated in the output directory.
    For example. I took 20 identical excel files and try to print them.
    And I get only 10 pdf file (through one). I get 1, 3, 5, 7 ect files.

    #5710

    gggeorggge
    Participant

    Any ideas? Maybe i need some delay between print?

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic.