#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 41
Default SendKeys

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.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
right-Alt with SendKeys Tom D Excel Programming 0 October 1st 07 09:07 PM
SendKeys Help ankur Excel Programming 2 January 17th 07 11:25 AM
SendKeys in VBA John Excel Programming 1 June 24th 05 05:46 PM
SendKeys? CMK Excel Programming 2 February 23rd 05 12:03 AM
Sendkeys GB[_3_] Excel Programming 0 September 16th 03 10:39 PM


All times are GMT +1. The time now is 10:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"