Tuesday, March 15, 2011

Periodically Import XML Data into Excel

This is a VBA app (run in Excel 2007) that I developed to automatically import online XML data into a Excel file every 1 minute.
Here is the download link
XML Data Importer

2 comments:

  1. This is interesting. I need to parse data in
    XML Document to Excel Worksheet. This is the
    XML file:





    Cust1234
    Smith
    New York


    MP3 Player


    Radio




    This well formed XML document feeds to Excel
    2007 using MS VBA code. I was successful
    with using DOMDocument and IXMLDOMElement to
    import the Name, City, and Product.

    However, the xa:MeContext id, Data1 id, Data2
    id, CustID, and order Orderid number
    won't export to Excel sheet. This should be
    simple. This is my first post here.

    Each Excel row has the following headers with
    data filled from XML document:

    MeContextID--vsData1--VsData2--CustID--Name--City--OrderID--Product--OrderID--Product

    ReplyDelete