A few tips:
1. Don't use Worksheet_Change whilst developing the code, as it requires you to enter data on the worksheet to trigger the code and you will need to flick between the worksheet and the VB editor. Just use a subroutine with a hard-coded keyword in a standard module and stay within the VB editor.
2. Don't use late binding (Dim ie As Object, Set ie = CreateObject..) whilst developing the code. Instead use early binding (Dim IE As Internet Explorer, Set IE = New Internet Explorer) for which you must set a reference to MS Internet Controls in Tools - References in the VB editor. Also set a reference to MS HTML Object Library for the IE.document object and its properties and methods.
3. For web page form names etc. use View Source in your browser.
For ubersuggest.org, there is an easier way than populating/clicking the form elements. Enter the search term and click 'Suggest', and at the bottom of the page there is a "Link to this query" hyperlink. For example, I searched for "Excel VBA training" and the link is http://ubersuggest.org/?query=Excel+...USA&source=web. This means you can query the search term directly without populating the form. Furthermore, we can use XMLhttp instead of IE to get all the suggestions, like this:
The XMLhttp object requires a reference to MS XML v6.0. Note that the spaces in "Excel VBA training" are replaced by + signs and / is replaced by %2F to encode the query string. You could use one of the functions at http://stackoverflow.com/questions/2...g-in-excel-vba to encode the query string.
I haven't looked at the Google Adwords part, but hopefully the above should give you some ideas.
LinkBack URL
About LinkBacks
Register To Reply
Originally Posted by excelseo
Bookmarks