software

I wish to print an excel doc every monday at 10.00 AM can this be set up in
automaticlyYou could use Windows Scheduler to open an Excel file at that
time, then put code in the Workbook_Open event procedure to do
the print and close the file.--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

quot;peerlessquot; gt; wrote in message
...
gt;I wish to print an excel doc every monday at 10.00 AM can this
gt;be set up in
gt; automaticly
gt;
Hi Chip Pearson

Thanks for your help, ive done the scheduler task but dont know how to do
the Workbook_Open event procedure bit can you help me a little more please
thanks

quot;peerlessquot; wrote:

gt; I wish to print an excel doc every monday at 10.00 AM can this be set up in
gt; automaticly
gt;

Open your workbook.

Record a macro while you print what you need.

Then rename this recorded macro Auto_Open() (or just name it Auto_open when you
start recording.

Auto_Open and the workbook_open even will both run when the workbook opens.

If you're new to macros, you may want to read David McRitchie's intro at:
www.mvps.org/dmcritchie/excel/getstarted.htm

peerless wrote:
gt;
gt; Hi Chip Pearson
gt;
gt; Thanks for your help, ive done the scheduler task but dont know how to do
gt; the Workbook_Open event procedure bit can you help me a little more please
gt; thanks
gt;
gt; quot;peerlessquot; wrote:
gt;
gt; gt; I wish to print an excel doc every monday at 10.00 AM can this be set up in
gt; gt; automaticly
gt; gt;

--

Dave Peterson