gantony
Feb 28th, 2001, 08:35 AM
Hi All,
I am using VBA to automate the printing of multiple reports from Excel. Since Excel has it's built in printout method, I use it. It works great, except for every page the code prints a "Now Printing ..." dialog box pops up. Is there a way to disable the dialog using any API calls? Or is there a way to send the Excel report directly to a printer using API calls, thereby totally bypassing Excel's printout method?
I have seen code which prints text from a form's textbox control directly to a printer(from Dan Appleman's book). I'm having difficulty in converting the code so that I can send a report with tables, charts and formating to the printer.
Any help regarding this matter will be greatly appreciated. Thanks in advance.
George.
I am using VBA to automate the printing of multiple reports from Excel. Since Excel has it's built in printout method, I use it. It works great, except for every page the code prints a "Now Printing ..." dialog box pops up. Is there a way to disable the dialog using any API calls? Or is there a way to send the Excel report directly to a printer using API calls, thereby totally bypassing Excel's printout method?
I have seen code which prints text from a form's textbox control directly to a printer(from Dan Appleman's book). I'm having difficulty in converting the code so that I can send a report with tables, charts and formating to the printer.
Any help regarding this matter will be greatly appreciated. Thanks in advance.
George.