VBA: Refresh XML Source – Updated

When updating an XML list I’ve been having better luck using XmlMaps().Import:

Sub RefreshXML()

Dim Feed As String

Feed = "http://blogdex.net/xml/index.asp"

'True for Overwrite, False for Append

ActiveWorkbook.XmlMaps("MyMap").Import Feed, True

End Sub

Rather than this.

As a side note. If you don’t have a practical reason to use Excel’s XML features, RSS feeds are XML based and fun to play with (the inspiration). Lately I’ve been experimenting with creating custom VBA filters for some of my feeds with too much noise.