Skip to main content

[archive] Printing from EXCEL

  • August 14, 2009
  • 2 replies
  • 0 views
D

[Migrated content. Thread originally posted on 13 August 2009]

I used the Excel OLE example to populate an excel sheet from AcuCobol.
I have allocated the printer using modify ex-app @ActivePrinter = printername
The printer will be dependent on which branch location is printing the report.
This does change the default windows printer.

My problem is that I can not direct the printing from a different paper tray.:confused:

I have tried:
MOVE 3 TO WINPRINT-CURR-TRAY.
CALL "WIN$PRINTER" USING WINPRINT-SET-PRINTER-EX
WINPRINT-SELECTION
GIVING WSS-PRINTER-RESULT.

When I call "WIN$PRINTER" USING WINPRINT-GET-PRINTER-INFO-EX, it looks like the paper tray was reset but the report continues to print out of the default paper tray.

The program is running through Citrix on a network. Any suggestions on how to direct the printing from another tray?

    2 replies

    D

    [Migrated content. Thread originally posted on 13 August 2009]

    I used the Excel OLE example to populate an excel sheet from AcuCobol.
    I have allocated the printer using modify ex-app @ActivePrinter = printername
    The printer will be dependent on which branch location is printing the report.
    This does change the default windows printer.

    My problem is that I can not direct the printing from a different paper tray.:confused:

    I have tried:
    MOVE 3 TO WINPRINT-CURR-TRAY.
    CALL "WIN$PRINTER" USING WINPRINT-SET-PRINTER-EX
    WINPRINT-SELECTION
    GIVING WSS-PRINTER-RESULT.

    When I call "WIN$PRINTER" USING WINPRINT-GET-PRINTER-INFO-EX, it looks like the paper tray was reset but the report continues to print out of the default paper tray.

    The program is running through Citrix on a network. Any suggestions on how to direct the printing from another tray?
    WIN$PRINTER operations have no effect on Excel printing.

    You will have to see if Excel itself provide a mechanism to set printer features.
    D

    [Migrated content. Thread originally posted on 13 August 2009]

    I used the Excel OLE example to populate an excel sheet from AcuCobol.
    I have allocated the printer using modify ex-app @ActivePrinter = printername
    The printer will be dependent on which branch location is printing the report.
    This does change the default windows printer.

    My problem is that I can not direct the printing from a different paper tray.:confused:

    I have tried:
    MOVE 3 TO WINPRINT-CURR-TRAY.
    CALL "WIN$PRINTER" USING WINPRINT-SET-PRINTER-EX
    WINPRINT-SELECTION
    GIVING WSS-PRINTER-RESULT.

    When I call "WIN$PRINTER" USING WINPRINT-GET-PRINTER-INFO-EX, it looks like the paper tray was reset but the report continues to print out of the default paper tray.

    The program is running through Citrix on a network. Any suggestions on how to direct the printing from another tray?
    WIN$PRINTER operations have no effect on Excel printing.

    You will have to see if Excel itself provide a mechanism to set printer features.

    Recent badge winners

    Explore all badges
    Terms & ConditionsAccessibility statement