Automatic printing
Automatic printing
(OP)
Is there a way to set up an EXCEL file to print a page automatically as per a specified schedule? What I am interested in doing is generating a hard copy report from an EXCEL file that is linked to DCS data. I would want it to print at 7AM every Monday morning. Any help is appreciated.





RE: Automatic printing
You'd be better off using a database and if that can't schedule tasks internally, then some bolt-on software like Crystal Reports.
RE: Automatic printing
As francesca stated you can use the task scheduler to automatically start excel.
You can also configure the task scheduler to open the specific file that you want excel to open easily enough.
Using VBA you can add the code to print it when the workbook opens.
It is easy enough to do.