Is there a way to set a time and date to print a worksheet automaticaly, say every monday at 9 am?
G Geo Oct 1, 2007 #1 Is there a way to set a time and date to print a worksheet automaticaly, say every monday at 9 am?
G Gord Dibben Oct 1, 2007 #2 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
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
G Geo Oct 2, 2007 #3 Thank you I shall try that -- Geo Gord Dibben said: 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 Click to expand...
Thank you I shall try that -- Geo Gord Dibben said: 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 Click to expand...
