ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Auto Print (https://www.excelbanter.com/excel-programming/292295-auto-print.html)

ben

Auto Print
 
Can you set excel up to automatically print out certain
sheets in certain workbooks based upon time like... 4:00
am and or 4:00 pm every day or M-F etc.?

Can this be done without having to open the file also?

Ben

Dave Peterson[_3_]

Auto Print
 
You could have an OnTime macro open the workbook, print the sheets, close the
workbook (and repeat).

Chip Pearson has some very nice notes for OnTime at:

http://www.cpearson.com/excel/ontime.htm

Excel will need to be running.

Ben wrote:

Can you set excel up to automatically print out certain
sheets in certain workbooks based upon time like... 4:00
am and or 4:00 pm every day or M-F etc.?

Can this be done without having to open the file also?

Ben


--

Dave Peterson



All times are GMT +1. The time now is 04:22 AM.

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