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.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"venu" wrote in message
...
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

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

"venu" wrote:

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