+ Reply to Thread
Results 1 to 2 of 2

XML string to Excel

Hybrid 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.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: XML string to Excel

    "Hi and welcome to the forum

    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code in [CODE] [/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    Also, please , in accordance with forum rules, please rename your thread to something more meaningful, that actually describes your problem.

    Because thread titles are used in searching the forum it is vital they be written to accurately describe your thread content or overall objective using ONLY search friendly key words. That is, your title used as search terms would return relevant results.

    Look at it this way...if you typed that title into google, what would you expect to get back?
    To change a Title on your post, click EDIT on you're 1st post, then Go Advanced and change your title"
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

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