Archive of Mr Excel Message Board
Back to Printing in Excel archive index
Back to archive home
auto print
Posted by Gary Barton on September 07, 2001 9:04 AM
Dear Mr. Excel,
I have an excel worksheet (office97) that is collecting
data on a continuous basis. I would like to print
the worksheet automatically 3 times a day.
Is this possible??
I thinks I need a vb macro but I don't know how
to do that yet.
Thanks, Gary
Re: auto print
Posted by Barrie Davidson on September 07, 2001 9:41 AM
Gary, try using this macro. Note that this assumes you have a macro for printing called "Print_Out".
Sub timer()
Application.OnTime TimeValue("10:00:00"), "Print_Out"
Application.OnTime TimeValue("13:00:00"), "Print_Out"
Application.OnTime TimeValue("16:00:00"), "Print_Out"
End Sub
You will have to run this macro at the beginning of the day and it will run the "Print_Out" macro at 10:00 am, 1:00 pm, and 4:00 pm. All you need to do is change the name of the macro to run (from "Print_Out") and the times you want to print.
Regards,
Barrie
http://ca.geocities.com/b_davidso
Re: auto print
Posted by Gary B on September 07, 2001 3:30 PM
Thanks you so much, Mr Davidson.
I was able to get it to work right away.
Will be checking out your web site too.
Gary
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.