Question Locked

Excel dynamic web query question

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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!

2 replies

by averma

Can anyone help me on the above-mentioned problem? VBA code, web query, anything. I could really use some help.

Thanks in advance!

This discussion is closed to new replies.