Hi,
I am trying to automate data entry from Excel to our inhouse software. most of my looping can be done using Application.SenKeys Method, such as Ctrl+C, Alt+Tab, Ctrl+V, Alt+Tab (and repeat the process til the end of loop).
However there are some issue with the inhouse software where when there are too many users using it at the same time causing the software to goes (NOT RESPONDING), therefore killing the sequence.
I have tried to use application.wait however I cant judge when is the software gonna go to (Not Responding) mode.
Is there any specific way to check using like LOOP (active application) is NOT RESPONDING then wait for x seconds, otherwise continue macro.
Thanks
Lex
Bookmarks