View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
programmernovice[_2_] programmernovice[_2_] is offline
external usenet poster
 
Posts: 61
Default Programmatic alternative to SendKeys

Hi, I'm finding that SendKeys is somewhat flakey, as noted by many people.

I'm using it in Excel to start and stop an external program, symbol "RLT", but it does not always work, that is it will start but then not stop. The same symbol "ST" is used for both actions.

The steps a

Application.SendKeys ("%")

Application.SendKeys ("RLT")

Application.SendKeys ("ST")

I have read that there is a VBA programmatic alterntive to this, can some please guide me on how to write it?

Many thanks for all help. AM