_Excel_Print() a Particular Worksheet

[litlmike 1]

I just need to print a particular worksheet using _Excel_Print(), but I don't know how to print a worksheet that is NOT the default activesheet.  How do I change 

_Excel_Print($oExcel, Default)

Into something like

_Excel_Print($oExcel, "ABC")

or 

_Excel_Print($oExcel, 3)

 

[Jfish 143]

_Excel_Print($oAppl,$oAppl.Worksheets("Sheet3")) ;swap "Sheet3" for the name of the sheet you want to print

 

[litlmike 1]

Thank you!

[Jfish 143]

Glad I could help.

[qwiqshot 0]

how do you print 1 copy of a specific range of a specific sheet while on another sheet?

I thought this would be it, but it does nothing, not even an error.

_Excel_Print($oExcel, "A1:M55", 1, $oExcel.Worksheets("Cover"))

this works fine, just need to know how to print "Cover" sheet range and then add to the very bottom without requiring moving to that tab. driving me nutty.

; print one page of contract for office copy
_Excel_Print($oExcel, "A1:M55", 1, "Xerox WorkCentre 7556 PS Plain Paper")
Sleep (500)
; print 2 copies for customer on legal paper (contract on back side)
_Excel_Print($oExcel, "A1:M55", 2, "Xerox WorkCentre 7556 PS Contract Paper")
Sleep (500)

 

[qwiqshot 0]

stumbled onto another article and adapted my line and now it does print the correct sheet from another sheet, but prints a ridiculous range

_Excel_Print($oExcel,$oExcel.Worksheets("Cover").Range("A1:M55"), 1, "Xerox WorkCentre 7556 PS Plain Paper")

I only want to print A1 thru M55. It is printing 5 pages of data off of the sheet I want printed from, lol

[qwiqshot 0]

Disregard, had  right margin set too far. Hope that helps someone out.