task scheduling

[venu]

how do i schedule a print job ....i have an excel file which has to be
printed at a particular time like morning and in the evening , do i have to
do this using task scheduler or is it something that has to be coded using a
macro........any coding example would be appreciated....

Thanks in advance

 

[Ken Slovak - [MVP - Outlook]]

How is this related to Outlook? If this is an Excel question please post it
in an Excel group.

 

[Stew J]

Hi Venu,
I have asked a similar question to this. Joel kindly gave me a coding
answer as follows
Sub openexcel()
'Dim wb As excel.workbook

FName = "C:\temp\book1.xls"
Set xlApp = Application.CreateObject("Excel.Application")
Set xlbook = xlApp.Workbooks.Open(FName)
xlbook.PrintOut

End Sub

this works from the macro function in outlook 2003, unable to schedule as
yet. Still looking

Stew