>>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 :-)
Oh, and one more question: What would happen if I wanted to print the entire spreadsheet, as in
loWorkbook.PrintOut()
but also have the print dialog appear? Are those two requests compatible?
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)