>I tried to give the users the option to print immediately from a report generated for Excel, i.e., without even showing the file on screen. IIRC, I used the PrintOut() method; both of the following worked:
>
>

>loSheet.PrintOut()
>

>
>and
>
>

>loWorkbook.PrintOut()
>

>
>(Or some equivalent, according to the classes used.)
>
>Two questions:
>
>1. This command prints immediately, to the default printer. Is there a way to have the print dialog appear, e.g. to select a different printer?

#define xlDialogPrint 8
eExcel.Dialogs(xlDialogPrint).Show

>
>2. I suspect that loWorkbook.PrintOut() will print all sheets in the workbook - can anyone confirm this?

Confirmed :-)