ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Setting up automated print function in VB (https://www.excelbanter.com/excel-discussion-misc-queries/136109-setting-up-automated-print-function-vbulletin.html)

Harmon

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