PDA

View Full Version : Scheduling a Printing Task


tomwesnick
December 5th 03, 01:34 AM
Is there a way for the built-in Task Scheduler to automatically print
a Microsoft Excel Document everyday at a certain time? I've already
tried to fool around with it but didn't get anywhere. This spreadsheet
also has one macro, which when run it prints the document. (Can I skip
this step of manually running the macro?) Thanks for all the help.

Thorsten Matzner
December 5th 03, 01:34 AM
(tomwesnick) wrote:

>Is there a way for the built-in Task Scheduler to automatically print
>a Microsoft Excel Document everyday at a certain time?

Have you tried the /e switch in an Excel command-line:
"C:\Programs\Office10\OFFICE10\EXCEL.EXE" {filename} /e

--
(tm)

tomwesnick
December 5th 03, 01:35 AM
Thorsten Matzner > wrote in message >...
> (tomwesnick) wrote:
>
> >Is there a way for the built-in Task Scheduler to automatically print
> >a Microsoft Excel Document everyday at a certain time?
>
> Have you tried the /e switch in an Excel command-line:
> "C:\Programs\Office10\OFFICE10\EXCEL.EXE" {filename} /e

I have not tried the /e switch comand-line. How does it work or what should I do?

Thorsten Matzner
December 5th 03, 01:36 AM
(tomwesnick) wrote:

>I have not tried the /e switch comand-line. How does it work or what should I do?

This is the command-line that is executed when you right-click an XLS
file and choose "Print": Excel starts and prints the file.

--
(tm)

Google