Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi there,
I am working my way through xml and am stuck with a small problem. I am currently downloading all of the xml of a particular site but I only want the tag of ("Openings"). Below is the code that I am using to download the data: Sub stockp() Dim oXMLDOMElement As New MSXML2.DOMDocument30 Dim nodelistOpenings As IXMLDOMNodeList Dim TestWebService As New clsws_stocks Set nodelistOpenings = oXMLDOMElement.getElementsByTagName("Openings") Set nodelistOpenings = TestWebService.wsm_stocks("1234", "ASX") Application.Goto Reference:="stockTarget" ActiveCell.FormulaR1C1 = nodelistOpenings.Item(0).Text End Sub The above doesn't provide the filter that I wanted ie I only wanted "Openings" but it provides all the data on the applicable page. Does anybody have any ideas? Regards, Andrew |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Problem with a very simple code in Visual basic | Excel Programming | |||
Can I run Visual Basic procedure using Excel Visual Basic editor? | Excel Programming | |||
Visual Basic problem | Excel Programming | |||
Visual Basic Problem with Chr(34) | Excel Programming | |||
Visual Basic Problem with Chr(34) | Excel Programming |