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

You 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

"peerless" wrote in message
...
I wish to print an excel doc every monday at 10.00 AM can this
be set up in
automaticly

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

"peerless" wrote:

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

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:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

peerless wrote:

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

"peerless" wrote:

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


--

Dave Peterson