![]() |
Setting up automated print function in VB
I am fairly new to VB. Can anyone give me an example to do the following:
I will use scheduled task to open up certain excel worksheets. When the scheduler opens the worksheet, I would like the worksheets to printout daily at ~7:30 am. The worksheet is already linked to a data process gathering software(ASPEN). The software pulls data from the process and incorporates into the worksheet. Which results in a daily report. After the worksheet prints out, I need it to save, and close. I also need a time delay about 2 minutes for some worksheets allow the ASPEN to pull in data and calculate some emissions. After 2 mintues, then printout report, save, close worksheet. Any thoughts... |
All times are GMT +1. The time now is 03:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com