print a excel doc

[Guest]

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

 

[Chip Pearson]

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

 

[Guest]

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

 

[Dave Peterson]

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