Excel to query a web page and return a filtered value

[msinn]

Apologies, Im sure this has been covered, but I have been unable to stumble across the correct search string to find the answer.

Briefly, I have a large table of molecules and values from an assay (10,000 rows). Each row is unique. I would like to be able to include a query that throws a search at ncbi based on the molecule name- something like

http://www.ncbi.nlm.nih.gov/pubmed/?term=oubain

and returns the number of results found (for this example its 101).

I have not been able to filter the page down from the standard web query interface. This has to be simple, but I haven't been able to figure it out.

 

[John_w]

I tried a web query on that URL (only the entire page could be selected for import) and it imported the data as XML columns and I was unable to get the number of results.

You might try an XMLhttp GET request instead and parse the response.