Search results for query: *

Since I'm learning as I go I'll answer my own question about the schema file. That file is used by the XLM parser to validate the XML file and is pointed to in the first couple of lines in the XML file. The schema file ending in .xsd

For those interested here is a link to get started on the object model of XML. I'm still working my way through it. Lots of information for someone who hasn't worked with it before. This begins the talk about XML and the Microsoft® XML Parser (Msxml.dll)...

Well now I'm confused. They supply a XML schema file which points to several others. Am I supposed to use this to gather all the elements/nodes/types? My goal here is only to grab a few items from the result XML file. Which I know the Tagnames. So I'm not sure if its needed. If it is....oh...

Well I'm getting it as I go. I figured out I needed to change. This line: Debug.Print objXMLElement.nodeName, objXMLElement.nodeValue to this: Debug.Print objXMLElement.nodeName, objXMLElement.Text Not sure why nodevalue would only return null. However, ".Text" seem to return the value...

the following is the sample output file they give on the site: >>>>>>>>>>>>>>>>>>> <?xml version="1.0" encoding="utf-8" ?> <SearchResults:searchresults xmlns:SearchResults="http://www. zillow.com/vstatic/3/static/xsd/SearchResults.xsd"> <request> <address>2114 Bigelow Ave</address>...

Ah well that gets me somewhere I'm getting the following: address Null citystatezip Null Paul

Wow looks great. I've inserted my ZWSID into the url line...however I don't seem to get any output from it. When I paste the url with that ID in it I get a raw url page. Which is what we are going for. So I"m confused. Shouldn't the data be printed to the current worksheet? Probably I'm so...

Hello, I need to send out a webservice call from VBA in excel 2000...that looks like this...>>>> http://www.zillow.com/webservice/GetDeepSearchResults.htm?zws-id=<ZWSID>&address=2114+Bigelow+Ave&citystatezip=Seattle%2C+WA >>>>>>>> This will return a page of xml that I will need to parse...once...

Oh no memory error with your code. Only with previous code so I've resolved both issues with your answer. Simple and quick just what I wanted! Thanks, again :)

Great thank you. Any ideas as to why I would get that memory error? Paul

I'm sure this is a simple question however for the life of me I cannot figure it out. First off I'm using VBA in excel 2000. I have a worksheet that gets information copied and pasted into it from the web(manually). When this happens it brings in an unknown number of Shapes("Picture 1") 's...