VBA: Refresh XML Source – Updated
When updating an XML list I’ve been having better luck using XmlMaps().Import:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 |
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.