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
Bookmarks