Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VBA_Web Services_IXMLDOMNodeList

Status
Not open for further replies.
redtulip

redtulip

Programmer
Apr 4, 2006
2
US
Hi,

In a nutshell, I have to write an Excel / Word macro what will consume a Web Service that will access an Oracle database to extract some information back to an Excel or Word template. I'm new to all of these technologies: VBA, Web Service and XML. After doing some reading online, I’ve figured out how to write some VBA code to call a web service, which involves simple input/output parameters such as a string or an integer. But, I don’t know how to call a web service method, where the input parameter is defined as “IXMLDOMNodeList”. To be more specific, the method I’m trying to call is:


Public Function wsm_AccountQueryPage(ByVal any_AccountWS_AccountQueryPage_Input As MSXML2.IXMLDOMNodeList) As MSXML2.IXMLDOMNodeList

I don’t have any more information than this. How do I create an object of MSXML2.IXMLDOMNodeList type? Is there any more information I should get before trying to tackle this?

Any help will be appreciated!
Thanks in advance!
 
Sort by date Sort by votes
sounds like its returning a XML feed, make sure you have in your references , Microsoft XML 4.0 selected,

I have something similiar where i post a xml file to a server, and get a return back as a XML file,

here is a snippet of code on what this look likes

Code: 
Dim xml_doc As New DOMDocument
Dim nde_Asset As IXMLDOMNode
Dim nde_Dividend As IXMLDOMNode

xml_doc.Loadxml (xml_Http.ResponseText) ' response text is the xml file being returned 

For Each nde_Asset In xml_doc.selectNodes("//Asset")

    str_FundCode = nde_Asset.selectSingleNode("FundCode").Text
    str_distribution = nde_Asset.selectSingleNode("IncomeDistribution").Text

etc etc



Chance,

Filmmaker, taken gentleman and He tan e epi tas all change on monday
 
Upvote 0 Downvote
Hey Chance,

Thanks for the reply.

Yes, I have selected Microsoft XML 4.0 in my references. Looking at your code, I see that you are parsing through the XML doc you received from the server, right? My problem isn’t how to parse the returned XML doc from the server but, how to pass the input parameter as IXMLDOMNodeList so that the method will interpret it. :( I’d appreciate it if you could post any examples which did something of such sort.

Thanks! :)
Sweetpea

 
Upvote 0 Downvote
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top