Options

xlWorkbook.PrintOut(1,10,1,FALSE,txtPrinterName,FALSE,FALSE)

AndwianAndwian Member Posts: 627
Dear Expert,

I found this code in a report that printed to Excel:
xlWorkbook.PrintOut(1,10,1,FALSE,txtPrinterName,FALSE,FALSE);

Could someone kindly explain to me about the parameter please?

Thans you in advance.
Regards,
Andwian

Answers

  • Options
    MGM08MGM08 Member Posts: 41
  • Options
    AndwianAndwian Member Posts: 627
    Thank you MGM08 :D
    Regards,
    Andwian
  • Options
    AndwianAndwian Member Posts: 627
    Parameters

    From
    Type: System.Object
    The number of the page at which to start printing. If this argument is omitted, printing starts at the beginning.

    To
    Type: System.Object
    The number of the last page to print. If this argument is omitted, printing ends with the last page.

    Copies
    Type: System.Object
    The number of copies to print. If this argument is omitted, one copy is printed.

    Preview
    Type: System.Object
    true to have Microsoft Office Excel invoke print preview before printing the object. false to print the object immediately.

    ActivePrinter
    Type: System.Object
    Sets the name of the active printer.

    PrintToFile
    Type: System.Object
    true to print to a file. If PrToFileName is not specified, Excel prompts the user to enter the name of the output file.

    Collate
    Type: System.Object
    true to collate multiple copies.

    PrToFileName
    Type: System.Object
    If PrintToFile is set to true, this argument specifies the name of the file you want to print to.
    Regards,
    Andwian
Sign In or Register to comment.