Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Schedule Print Excel Document
I have a Excel report I need to print automatically every morning, generally
before I get in. I can use the scheduler to open the spreadsheet, I don't need to update the data, just print it. Don't even need to open the spreadsheet unless necessary. Is there a command line switch I can use to just print the document without leaving the document open. Sort of like if you right click and select print on a document. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Schedule Print Excel Document
You can place in the Workbook_Open event a command to print and then close
the workbook. Something like the following in the ThisWorkbook part of the code: Private Sub Workbook_Open() ActiveWorkbook.PrintOut Copies:=1, Collate:=True 'prints entire workbook Application.Quit 'closes excel End Sub Only thing is that you would have to either digitally sign the file so you wouldn't have to approve macros on opening, or set security to low. "RWG" wrote: I have a Excel report I need to print automatically every morning, generally before I get in. I can use the scheduler to open the spreadsheet, I don't need to update the data, just print it. Don't even need to open the spreadsheet unless necessary. Is there a command line switch I can use to just print the document without leaving the document open. Sort of like if you right click and select print on a document. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I schedule a task to print a document | Excel Discussion (Misc queries) | |||
Excel document print | Excel Discussion (Misc queries) | |||
why won't excel print my document? | Excel Discussion (Misc queries) | |||
how do i rotate a document or print small document on envelope | New Users to Excel | |||
How do I print the name of a tab on an Excel document? | Excel Discussion (Misc queries) |