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?
2. I suspect that loWorkbook.PrintOut() will print all sheets in the workbook - can anyone confirm this?
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)