task scheduling

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 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
 
C

ctm

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top