I want keyboard maestro to loop approximately 10000 times through a list of URLs in excel. Each link is loaded in Safari and returns a table with information (which sometimes might be empty). Up to this point, everything works as expected, however, the macro skips certain keystrokes after a certain amount of repetitions. In this case, after it copies the text from the browser, the macro should go over to another sheet in Excel an paste the information into the next empty row (CMD + Down Arrow). This step is on that is skipped, because it pastes the information on top of another cell already containing previous data.
This happens in my case after the 2104th URL and the respective 18406th pasted dataset (other sheet). I ran this macro on another computer with a higher CPU and more RAM and somehow the result is the same. It somehow start skipping at 18000-20000 datasets. Each URL may return many datasets, which is why the other sheet contains more datasets than actual URLs.
I added certain timed pauses in between each action. Is there a way to wait for each action to be simulated? There is an option to pause until the keystroke or key combination is pressed, but in this case it is not pressed but rather simulated.
Maybe use another spreadsheet application which is more lightweight than Excel? Any recommendation?
I want this macro to be as fast as possible given that I have to run sometimes even more than 10000 perhaps 100000 loops.
It is important to note that Keyboard Maestro increases the CPU% usage. I deduce that this might be due to the loops accumulating. Each loop should not really have too much CPU% usage, hence, how can this macro be built more efficiently?
This is the macro:
Parser.kmmacros (15.9 KB)
Thanks,
Anthony