| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print automatic
Is there a way to set a time and date to print a worksheet automaticaly, say
every monday at 9 am? -- Geo |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatic update of spreadsheet & automatic update between workboo | Excel Worksheet Functions | |||
| "Print Selection" doesn't print beyond automatic page breaks | Excel Discussion (Misc queries) | |||
| Print Breaks-Automatic or Force New | Excel Worksheet Functions | |||
| Pivot Table macro to set print area and print details of drill down data | Excel Discussion (Misc queries) | |||
| Is there an automatic display/print the filename on sheet in Exce. | Excel Discussion (Misc queries) | |||
Linear Mode
