task scheduling

  • Thread starter Thread starter venu
  • Start date Start date
V

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
 
How is this related to Outlook? If this is an Excel question please post it
in an Excel group.
 
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
 
Back
Top