Wednesday, May 28th, 2008 171 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 »
Wednesday, February 27th, 2008 307 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 »
