SendKeys

D

donflak

I am attermpting to use Sendkeys to select duplex printing when my job
prints.

The code I have is:

'
Sheets(Array("DISTRICT ROLL-UP", "FUNC 1", "FUNC 2B", "FUNC 4",
"OTHER", "Functional Summary")).Select
Sheets("DISTRICT ROLL-UP").Activate
ActiveWindow.SelectedSheets.PrintOut ActivePrinter:="\
\CLVDOHSXF01\44101C350521N80"
Application.SendKeys "{TAB}{TAB}{TAB}{TAB}{TAB}{TAB}{ENTER}", True
Application.SendKeys "{TAB}" ''' Choose
Finishing tab"
Application.SendKeys "{TAB)" ''' Check "Print
on both sides"
Application.SendKeys "{ENTER}{ENTER}", True
End Sub

The difficulty appears to begin with the "Choose Finishing tab"
command.

Please take a look and see if you can spot any deficiencies.

Thanks in advance for your assistance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top