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 after connecting
to a database , do i have to do this using task scheduler or is it something
that has to be coded using a macro........can anyone post a detailed coding
example..as i am a newbie in VB.... any kind of help would be appreciated....

Thanks in advance

You could use Windows 'Scheduled Tasks' to Open the workbook at the required
time.
Then add the Print option to the 'Workbook Open event'.


"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 after
connecting
to a database , do i have to do this using task scheduler or is it
something
that has to be coded using a macro........can anyone post a detailed
coding
example..as i am a newbie in VB.... any kind of help would be
appreciated....

Thanks in advance