I am trying to extract the LEI and name from the following website:
https://www.gmeiutility.org/search.jsp
As an example, search for "Pafco Insurance Company".
The first column contains LEI and the second contains legal name. I want to copy these first two values from the two columns and paste them into my sheet.
How would I do that?
This is what I have so far.
Two other questions (more out of interest than necessity):
1. What's the best way to handle "waiting"? I have
but that doesn't feel too elegant.
2. Is there a way to do this without actually opening internet explorer?
Bookmarks