Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
There is one way - go to ThisWorkBook in VBE and paste the following code Private Sub Workbook_Open() Range("$A$1:$M$30").PrintOut Copies:=1, Collate:=True Application.DisplayAlerts = False Application.Quit End Sub Change the range to suit your print area and then schedule a task to open that Excel file. So when it opens it will print it then close it (without saving). This is untested code as I do not have printer at the moment. If you want open the workbook without printing the code hold down Shift before opening. Tom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 printing problem--printing 1 document on 2 pages | Excel Discussion (Misc queries) | |||
Limited Page Printing problem; Blue Dashed Line Delineating End Of Document ? | New Users to Excel | |||
command line Excel Script | Excel Discussion (Misc queries) | |||
Disabling Document AutoRecovery in Excel by script | Excel Discussion (Misc queries) | |||
Using Excel 2000 as Data source for Word 2000 document | Excel Discussion (Misc queries) |