Re: Importing XML through .NET Web Service with VBA

Tech-Archive recommends: Speed Up your PC by fixing your registry


Thanks for the reply. Do you have any code that demonstrates how to
"open the XML directly as a recordset and use copyfrom recordset"? That
would be extrememly helpful.

Also, when you return a string type from the web service, it
automaticall puts string tags around my xml file data like this,
<string>... all my xml ... </string>. I am having some trouble parsing
the XML, could this be the cause? Do I need to strip out the <string>
tag? I tried to return a type of XMLDocument... but I then did not know
how to handle the object when it was reuturned from the WebService. Any
ideas?

Thanks again for the prompt reply.


--
brazilnut
------------------------------------------------------------------------
brazilnut's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29411
View this thread: http://www.excelforum.com/showthread.php?threadid=491228

.

Quantcast