Self-taught Excel VBA noob here.
I have scowered the internet far and wide to get to the point I'm at right now - which is stuck.
Through VBA I can launch Internet Explorer, load a web site, enter my search string into a field on the screen, click the web site's "Submit" button, and post the data of the resultant data table into an Excel Worksheet using a Web Query.
Now I need to select the next page on the web site and have been unable to do so.
Here's the web site: http://www.bcad.org/clientdb/?cid=1
Enter the first two letters of your last name in the search field and hit enter.
A page will load with the results. At the bottom right of the screen you'll see the hyperlinks to the other pages of the table. What is the code in VB to select those pages?
I've tried this, and it doesn't work:
URL = "http://www.bcad.org/clientdb/SearchResults.aspx?rtype=address&page" & cycle & " "
IntExplApp.Navigate URL
Do While IntExplApp.Busy
Loop
Also, if there's an easier way of collecting the table data than a web query I would love to know.
Thanks in advance!
Chris
Bookmarks