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

On Thursday, February 27, 2020 at 12:44:02 PM UTC-6, GS wrote:
Because I may need to turn on or off the data feed when I'm not around to
click it manually, which happens quite often. As an example, if the market
generating the numbers closes at a given hour, the feed must be turned off
just prior to the close, or else the numbers received after the close are
meaningless.


Ok, so how are you managing this when not at the computer?

--
Garry


With a simple Sendkeys macro (I have shown it in my original post). It works sometimes, sometimes not. That's the reason I thought there may be a "deeper" programmatic way to do it.

Thanks again.