I am looking for a way to schedule an Excel Document to automatically
print using the scheduled Tasks of Windows XP. I can't for the life
of me figure out if a command line switch exists for doing such a
thing, and was wondering if anyone has been able to do this.

Thanks for your thoughts.

Michael Stavropoulos

Hi

There is one way - go to ThisWorkBook in VBE and paste the following
code

Private Sub Workbook_Open()

Range("$A$1:$M$30").PrintOut Copies:=1, Collate:=True
Application.DisplayAlerts = False
Application.Quit

End Sub

Change the range to suit your print area and then schedule a task to
open that Excel file. So when it opens it will print it then close it
(without saving).

This is untested code as I do not have printer at the moment. If you
want open the workbook without printing the code hold down Shift before
opening.

Tom