March 6, 2006

Downloading and Parsing RSS Feeds

Filed under: Automation,Scripting — Marcus Tettmar @ 9:25 am

Probably the simplest way to parse XML, such as an RSS feed, is to use Microsoft’s MSXML object which is built into Windows. I wrote a very quick and dirty routine using MSXML2 to download and parse this blog’s RSS feed. All it does is put the title, link and content of each item into arrays. You can then get the data easily by querying the array. My example runs a VBScript function which populates the arrays and then some native MacroScript loops through the array showing the data in a message box, as a simple example. You will find my code on the forum, here.