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

Andwian

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.

MGM08

http://msdn.microsoft.com/en-us/library ... ntout.aspx

i hope this helps.

Andwian

Thank you MGM08

Andwian

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.