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...