Hello,
I’m trying to do a dynamic web query within excel to get specific information fields from a website. I have been somewhat successful in getting one of the fields, but unfortunately I’m a newb and not sure how to advance. Any help would be greatly appreciated.
The website I’m trying to get information from is (example: http://assignments.uspto.gov/assignments/q?db=pat&qt=pat&reel=&frame=&pat=5483640&pub=&asnr=&asnri=&asne=&asnei=&asns=)
I need to be able to pull the last assignee, just the name of the individual/company. There are sometimes multiple assignees, the one I have to pull is the one with the latest date (therefore, the fields are variable). Next thing I need to get is the Application number (Example: Application #:08023927).
Below is the query code I have this far. Any help would be really appreciated.
———————
WEB
1
http://assignments.uspto.gov/assignments/q?db=pat&qt=pat&reel=&frame=&pat=[“number”, “Enter Number:”]&pub=&asnr=&asnri=&asne=&asnei=&asns=
Selection=4
Formatting=None
PreFormattedTextToColumns=False
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
DisableDateRecognition=False
DisableRedirections=False
—————————————-
Thanks!
