I have a strange problem when trying to enter data into a target field of an application. Due to various reasons, please believe me when I tell you, the target applications name does not matter: it’s for sure not a “standard” application.
- Read Excel
- For each row (Datatable)
- Type into field row(7).ToString, SimulateType
- Commit via “Do”-Button
If I check, the target field is always empty after the commit. An interesting fact is: it does write the full excel table (with quite some text) in “one” step (you can’t see it typing…).
If I remove the “SimulateType”, it’s typing until the first “cr,lf” and then jumping around in the target application. It’s much slower as well (of course), so I would like to use “SimulateType” if possible.
Did you face the same problems? What did you do against it? I had a separate “Type Into” with some “Dummy text” (I can filter out afterwards, it does not matter for the sake of it) without “SimulateType”. After that, it usually stored data in the dev environment (this was reliable). But in the “test” environment, it’s not anymore.
How do you filter “cr” and “lf” from an excel input? tried replace(vbCrLf, “”) and similar - it does not seem to capture it at all…
You can safely assume that the application is fully loaded and ready to take any input (in fact, I also worked with static delaysbefore, delaysbetweenkeys, etc.).
Your help is really appreciated.