Web scraping with xml

**abousetta** · 09-23-2012, 06:28 PM

Hi,

Can anyone help me finish this macro? I have the following but can't get the innertext.

Please Login or Register  to view this content.

Thanks.

abousetta

**Kyle123** · 09-24-2012, 03:40 AM

If it's just xml, use the xml document object, it's much easier than trying to stuff xml in an html object:

Please Login or Register  to view this content.

I've assumed that you wanted the count for the overall results, there are multiple count properties in the document

**abousetta** · 09-24-2012, 04:05 AM

Thanks Kyle. This is exactly what I needed. As I learn XML more, my needs will probably change in future tasks but for the current project, I just wanted to extract the count.

Have a great Monday.

abousetta

**Kyle123** · 09-24-2012, 04:24 AM

Thanks for the feedback, glad you got it sorted

You like that website don't you?

I seem to remember some long thread where you were trying to extract journal summaries from a JSON webservice that were based on that site.

**abousetta** · 09-24-2012, 05:25 AM

Yes, pubmed is one of the most frequented websites for medical (journal) information. It's the free portal to the National Library of Medicine's Medline database. I practically search it daily for one reason or another. As part of my work, we have to do extensive searches of PubMed along with other medical citation databases and automating the process has taken a great deal of load off me, but the learning curve is really more like a rocky road than a curve

.

Thanks again for all your help and insight.

abousetta