print a excel doc
 

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

print a excel doc
 

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

print a excel doc
 

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

print a excel doc
 

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