Create a Macro that Data mines a web page without any tables
This project received 13 bids from talented freelancers with an average bid price of $352 USD.Get free quotes for a project like this
Project Budget$250-$750 USD
I am trying to create a data mining macro in excel that will let me get information from a webpage ([url removed, login to view]). The proble is that the web page does not use tables, rather the code uses standard HTML coding.
The second problem is that there are levels and each level has several pages for example:
Level 1: State Names ([url removed, login to view]
Level 2: After selecting a state i might have to select a general regon ex:
[url removed, login to view]+Capital&id=DF
Gives me the choice between: Caracas, El Junkquito
Level 3: Lets say i select Caracas, then a face the alfabet list (i want all of them) but for example lets select the leter A.
Level 4: This opens a web page with two colums of names and about 46 others that are linked at the bottom (page 1,2, 3 etc.)
Level 5: Lets grab the first name, that sends me to another page where i have the information i want to get to. This page has Name, telefon, zone (might be missing) and state.
In this page there might be 1 to [url removed, login to view] names but only 15 will be showing at any giving time per page so the macro will have to crawl to get to the information.
Can anyone help me?
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online