Re: Scheduling an Excel Print Job

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Leslie,

As far as I'm aware the only way to schedule a DOS Batch program is on boot
up of the PC, so the batch program will only run when the PC is started up.
You can have a VBA code running in Excel but it means that your Excel
spread*** has to be running all the time.
What you are after is a small program that is always running in the
background, while the PC is on.
At the scheduled date/time it activates the spread*** and prints.

HTH

Dean
"Leslie" <Leslie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5059F39C-2C94-43E5-A15F-4302487E6BC6@xxxxxxxxxxxxxxxx
>I have an SQL DTS package that extracts data to an Excel spread***. I
> would like to schedule that Excel spread*** to print. Can I do that in
> a
> batch file from DOS? If so, what is the syntax for the batch file?
>
> Thanks!
> Leslie


.

Quantcast