ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   task scheduling (https://www.excelbanter.com/excel-programming/411412-task-scheduling.html)

Venu

task scheduling
 
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



ctm

task scheduling
 
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






All times are GMT +1. The time now is 08:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com