Home |
Search |
Today's Posts |
#1
![]()
Posted to alt.computer,microsoft.public.excel,microsoft.public.excel.newusers,microsoft.public.excel.printing,microsoft.public.excel.programming
|
|||
|
|||
![]()
Snippet of incomplete program:
*COPY* ActivePrinter = "Acrobat PDFWriter on FILE:": PrintToFile = True 'note need KILL statement for PDFWriter ' Above sets printer in Excel 2003; WILL crash in Excel 2010. num = 1 'here we try to select the diagram only; hope printer will use that For Each iobj In ActiveSheet.Shapes 'DrawingObjects iobj.Select If num = 5 Then Exit For 'got inserted "Picture 3"; want to print only this End If num = num + 1 Next iobj ' So..how do we pass it on? ' In "modern" defective Excel 2010, prints to default SO must set default to what is needed ' ActivePrinter = "Xerox Phaser 6120 PS on FILE:": PrintToFile = True ActiveWindow.SelectedSheets.PrintOut Copies:=1, Preview:=False, _ Collate:=False, PrToFilename:=pPath + vNam 'use + ".PS" for Xerox printer Kill pPath + vNam 'not needed for PS printer *END COPY* So..how do we pass it on or select it or whatever for printing? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I print an object in Excel 2007 | Excel Discussion (Misc queries) | |||
Print Word Object in Excel | Excel Discussion (Misc queries) | |||
Why does a pasted object in Excel sometimes print upside down? | Excel Discussion (Misc queries) | |||
Print more then one page in excel from a word object | Excel Worksheet Functions |