VBA basic script for reading xml data?? Resource for learning this method??

views:

305

answers:

+1 Q:

VBA basic script for reading xml data?? Resource for learning this method??

So I was just looking for basic examples of reading xml structure data with visual basic subs/scripts.

specifically, if possible, how can i take structure data of xml, read the data with some vba, and lay it into excel spreadsheets?

or just a learning resource for this type of thing. thanks very much!

+2 A:

These three topics will help you get started.

1) Load the XML using MSXML hint - XMLDOC.Load ("D:\folder\yourXML.xml")

2) Read the data with XPath or XML navigator

3) Build Excel Spreadsheet Using Microsoft Excel Object Model

Jason Rowe 2010-02-02 04:47:54

thanks...i do appreciate it! this will definately help alot!

Justin 2010-02-03 03:13:06

+1 A:

w3Schools has a good tutorial on the XML DOM.

Tester101 2010-02-02 13:57:43

+2 A:

http://www.dailydoseofexcel.com/archives/2009/06/16/reading-xml-files-in-vba/

http://www.dailydoseofexcel.com/archives/2010/01/21/culling-you-rss-feeds/

These aren't tutorials, just a couple of examples of XML in Excel that might help you identify the objects properties and methods. The first one from 2009 was my first attempt (read: it's terrible) but the comments were helpful for me so they might be helpful for you too.

Dick Kusleika 2010-02-02 16:19:06

this will help me...thanks for sure!

Justin 2010-02-03 03:09:33

@dkus I'm impressed that you even *attempted* to read XML from within VBA. Very well done and thanks for the link!

Ben McCormack 2010-02-03 14:32:10

ansaurus

tags:

views:

answers:

VBA basic script for reading xml data?? Resource for learning this method??

related questions