I'm working with Excel remotely, that is, using a secondary application and stuffing, retrieving data from an excel sheet using APIs. The trouble I have is that I send the API calls too fast! And yes, I can delay them with a timer or "FOR loops", whatever, but is there an API which tells you when an app like Excel is ready to take the next action, whether it be a mouse click or keyboard input? Something like a READY STATE...
(In case I have confused you. Some actions take time to perform in Excel, like when you call the GoTo director, which comes up as a little form or object asking "Where?" and showing you a list of tags. In that case you cannot fire API calls at Excel like a Gathing gun... So, I'm looking for a READY Flag)
TIA
Dennis