Assuming OCR is the hold up, would it be possible to process one while OCR'ing the other?
What if it was two bots. One bots job was to download the document, process the OCR, and save the raw text to a single cell. Then it was the second bots job to read the Excel text, parse it, and write to Excel.
The second bot doesn't need to focus text to work in Excel. It just bounces back and forth between the raw text workbook and the workbook you want to enter the parsed text on behind the scenes.
Your first bot needs to pass the %DataFromWebPage.RowsCount% to an Environment Variable for the second bot to pull: Set environment variable %LoopMax% to %DataFromWebPage.RowsCount%
Chances are, the second bot will outrun the OCR bot, so put in a proper [if data exists] function to force it to wait for data; your second bot should look something like this:
Get environment variable %LoopMax%
Loop starting at 2 (assuming a title row on the raw text excel file and on the output excel file) to %LoopMax% increment of 1
'Attach to Excel (raw text)
Create Label "Retry" 'we will come back here if there is no data
Read from Excel A & %LoopIndex% to %OCRText%
If %OCRText% is empty (or equals %''%) note: those are two apostrophes - not one quotation mark
Wait 5 (not necessary, but otherwise this will probably bog down your processing power as it continuously loops quickly)
Go to Label "Retry"
End (IF) 'so this will continue to loop through until %OCRText% is not empty.
'Parse Text (same as you did before)
'Attach to Excel (your output one)
'Write to Excel (same as before)
'Set variable %OCRText% to %''% (those are two apostrophes - not one quotation mark)
Best of luck!
