Getting Data from Web Query
Posted on 2011-05-02
Have a website.... Parent page contains multiple license numbers.... Need to "click" each license number... Then next page presents with data I need t capture in a web query within excel...
There are a total of 15 entries on the parent page; however, there are approximately 615 of the parent pages, with the undelying data I need to get at on a seperate page that is accessed by clicking one item on the parent page.... I know that I can create a Web Query that will extract information from one page; however, I need to progrommatically step through each parent page, and then bring up each of the 15 "child" pages, and extract the data from the "child page...
Any suggestions, or resources I could consult to accomplish??
Thanks in advance.
Rick D Norris, CPA
Conrad, Burnett, Norris, and Gordon, LLC