Print automatic
 

Is there a way to set a time and date to print a worksheet automaticaly, say
every monday at 9 am?
--
Geo

Print automatic
 

One method...............

Use Windows Task Scheduler to start Excel with a shortcut to the workbook in
question.

Run a print macro from a Workbook_Open event in the workbook.

Also add a line or lines or code to save then close the workbook and shutdown
Excel.


Gord Dibben MS Excel MVP


On Mon, 1 Oct 2007 13:17:01 -0700, Geo wrote:

Is there a way to set a time and date to print a worksheet automaticaly, say
every monday at 9 am?

Print automatic
 

Thank you I shall try that
--
Geo


"Gord Dibben" wrote:

One method...............

Use Windows Task Scheduler to start Excel with a shortcut to the workbook in
question.

Run a print macro from a Workbook_Open event in the workbook.

Also add a line or lines or code to save then close the workbook and shutdown
Excel.


Gord Dibben MS Excel MVP


On Mon, 1 Oct 2007 13:17:01 -0700, Geo wrote:

Is there a way to set a time and date to print a worksheet automaticaly, say
every monday at 9 am?