View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Sendkeys VBA and command line

Sendkeys will always send to the active window. When you are in the VBE,
that is the active window, that is where they go. Nothing you can do about
that.

Show the code and tell us what is required and what you get.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Bobsa" wrote in message
om...
I'm trying to control an object instantiated from Excel with VBA and
sendkeys to it. But cannot get it to work.

All that happens when I step through it in the VB Editor is that the
sendkeys data are sent to the VBEditor window.

I can fire up a window cmd.exe and activate it with AppActivate but
nothign else goes to it. Anyone help on this one??

Bobsa