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.
Eng-Tips is the largest engineering community on the Internet
Intelligent Work Forums for Engineering Professionals
-
Congratulations waross on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Automatic printing
- Thread starter Zoobie
- Start date
You can use Microsoft Scheduler (Programs --> Accessories --> System Tools --> Scheduler) to run Excel. But that won't open your file or even print the file. You could write a script that will open your file and print it, but you'll have to be pretty sharp with scripts and Windows to do that.
You'd be better off using a database and if that can't schedule tasks internally, then some bolt-on software like Crystal Reports.
You'd be better off using a database and if that can't schedule tasks internally, then some bolt-on software like Crystal Reports.
Zoobie,
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.
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.
- Status
Similar threads
- Locked
- Question