Hi
I am trying to read an RSS feed with the following:
However I don't know how to make it show the link - an example of a node is here:
I am trying to read an RSS feed with the following:
Code:
Set xmlDOM = CreateObject("MSXML2.DOMDocument")
xmlDOM.async = False
xmlDOM.setProperty "ServerHTTPRequest", True
xmlDOM.Load("[URL unfurl="true"]http://www.bwbllp.com/events/feed/")[/URL]
Set itemList = xmlDOM.getElementsByTagName("entry")
For Each item In itemList
'Parse the item children
For each child in item.childNodes
wscript.echo(child.nodeName)
Select case lcase(child.nodeName)
case "title"
title = child.text
wscript.echo(title)
case "link"
link = child.text
wscript.echo(link)
End Select
Next
Next
Set xmlDOM=Nothing
However I don't know how to make it show the link - an example of a node is here:
Code:
<entry>
<title>Launch of Best to Invest?</title>
<id>tag:[URL unfurl="true"]www.bwbllp.com,2013-07-08:/events/2013/07/08/launch-of-best-to-invest</id>[/URL]
<updated>2013-07-08T15:20:15+01:00</updated>
<author>
<name></name>
</author>
<link href="[URL unfurl="true"]http://www.bwbllp.com/events/2013/07/24/launch-of-best-to-invest"[/URL] rel="alternate"/>
<content type="html"><div><p>Best to Invest?, which has been generously funded by the Golden Bottle Trust, is a practical guide to social investment which aims to help funders to decide whether social investment is suitable for them in principle, and if so, how to go about it. It provides a checklist of issues to think about before making a social investment, particularly addressing the topic of whether the potential investment will create the same kind of social impact as a grant. It also addresses some of the risks and legal aspects that funders need to take into consideration before making a social investment.</p>
<p>The report has been written for trusts and foundations as well as individual investors interested in social investment and includes case studies of different types of investors who have engaged in a variety of ways in this field.</p>
<p>The event will be chaired by Alexander Hoare, C. Hoare &amp; Co. with a lively Q&amp;A session after presentations from the report authors:</p>
<p>Sarah Hedley and Abigail Rotheroe, NPC; and Luke Fletcher, Bates Wells Braithwaite.</p>
<p>Timetable<br>5:45pm Registration<br>6:15pm Presentations and Q&amp;A<br>7:30pm drinks and canap&eacute;s</p>
<p>Signing up<br>Please contact Rebecca Goodbourn on events@thinknpc.org, or 020 7620 4862.</p>
<p>&nbsp;</p></div></content>
<published>2013-07-08T15:14:43+01:00</published>
</entry>