Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Reading RSS feed

Status
Not open for further replies.

emozley

Technical User
Jan 14, 2003
769
GB
Hi

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">&lt;div&gt;&lt;p&gt;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.&lt;/p&gt;&#13;
&lt;p&gt;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.&lt;/p&gt;&#13;
&lt;p&gt;The event will be chaired by Alexander Hoare, C. Hoare &amp;amp; Co. with a lively Q&amp;amp;A session after presentations from the report authors:&lt;/p&gt;&#13;
&lt;p&gt;Sarah Hedley and Abigail Rotheroe, NPC; and Luke Fletcher, Bates Wells Braithwaite.&lt;/p&gt;&#13;
&lt;p&gt;Timetable&lt;br&gt;5:45pm Registration&lt;br&gt;6:15pm Presentations and Q&amp;amp;A&lt;br&gt;7:30pm drinks and canap&amp;eacute;s&lt;/p&gt;&#13;
&lt;p&gt;Signing up&lt;br&gt;Please contact Rebecca Goodbourn on events@thinknpc.org, or 020 7620 4862.&lt;/p&gt;&#13;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;/div&gt;</content>
    <published>2013-07-08T15:14:43+01:00</published>
  </entry>
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top