scheduler printing off excel document

[benjamintheblue]

I am trying to use my pc windows task scheduler to automatically print off a document called square numbers. I am using the command below and this brings the document up at the right time.

run "C:\WINNT\Profiles\benjamin\Desktop\ben\SQUARE NUMBERS.xls"
start in "D:\Program Files\Microsoft Office\Office"

I guess this would work through dos also, but I cant seem insert /p anywhere that will make it work.
I have tried run /p "C:\WINNT\Profiles\langton_ae\Desktop\andy\SQUARE NUMBERS.xls"
anyone help in this type of stuff?
or possibly some visual basic that when the document is opened it will print. Then this might work. Thanks Ben

 

[Smitty]

I can't help with the scheduler part, this will print all the worksheets when the wb is opened:

<font face=Tahoma><SPAN style="color:#00007F">Private</SPAN> <SPAN style="color:#00007F">Sub</SPAN> Workbook_Open()
    <SPAN style="color:#00007F">Dim</SPAN> ws <SPAN style="color:#00007F">As</SPAN> Worksheet
        <SPAN style="color:#00007F">For</SPAN> <SPAN style="color:#00007F">Each</SPAN> ws <SPAN style="color:#00007F">In</SPAN> ActiveWorkbook.Worksheets
            <SPAN style="color:#00007F">If</SPAN> Application.CountA(ws.Cells) <> 0 <SPAN style="color:#00007F">Then</SPAN> ws.PrintOut
        <SPAN style="color:#00007F">Next</SPAN> ws
<SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>

The code goes in the ThisWorkbook module.

HTH,

Smitty