XML Parsing Function

Wednesday, May 28th, 2008 253 views

In keeping with my Website XML parsing post, here is a short function that returns the body text from a webpage as a string, on which you can use other functions like Instr, Left$, Mid$, etc, to extract necessary data. [vba] Function URLText(sURL As String) As String ' check website.com using xml ' early ...

Posted in Excel, Internet Explorer, VBA, automation | 1 Comment »

Website Parsing/Retrieval using XML

Wednesday, February 27th, 2008 451 views

I recently posted links to the HTML and Internet Explorer object references. These are excellent tools to get web data into MS Office for further processing. Lately I have been reading into XML as it appears to be a much faster way to access web pages than instantiating Internet Explorer. My ...

Posted in Excel, Internet Explorer, VBA, automation | No Comments »