Archive for the ‘Internet Explorer’ Category
Wednesday, May 28th, 2008 191 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 »
Tuesday, April 29th, 2008 332 views
One of the most popular pages on this site shows code for automating Internet Explorer. However I have only tested the code in Excel XP/2003. The purpose of this post is to credit a gentleman named Durand Sinclair who, using Excel 2007, pointed out to me that the name of ...
Posted in Excel, Internet Explorer, VBA, automation | 3 Comments »
Wednesday, February 27th, 2008 333 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 »
Wednesday, February 20th, 2008 93 views
As part of my code section on automating Internet Explorer, here are the links to the object libraries being used. Very useful, I recommend experimentation to find the right way to access whatever website you are trying to integrate with.
DHTML Object Reference
Internetexplorer Object Reference
I was not able to find a ...
Posted in Excel, Internet Explorer, VBA, automation | No Comments »
