Results 1 to 2 of 2

XML string to Excel

Threaded View

  1. #1
    Registered User
    Join Date
    04-15-2013
    Location
    Phila
    MS-Off Ver
    Excel 2010
    Posts
    2

    Post XML string to Excel

    Dim sessionToken As String
            Dim idoDataSet As MSXML2.IXMLDOMNodeList
            Dim idoDocument As MSXML2.DOMDocument
            Dim idoWS As New clsws_IDOWebService
            
            sessionToken = idoWS.wsm_CreateSessionToken("user", "passord", "Dev1_PHIL")
            Set idoDataSet = idoWS.wsm_LoadDataSet(sessionToken, "SLPoItems", "PoNum, PoLine, PoOrderDate, PoStat, Item, QtyOrdered", "", "", "", 100)
            Set idoDocument = New MSXML2.DOMDocument
            idoDocument.async = False
            idoDocument.LoadXML idoDataSet.Item(1).XML
            
            Msgbox(idoDocument.xml)
    ' I need Code to Load the Data to Excel Sheet

    Moderators note: code tags added for you - this time
    Last edited by FDibbins; 04-16-2013 at 02:25 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1