Create a Macro that Data mines a web page without any tables

Closed

Description

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?

Skills: Data Entry, Data Processing, Excel

See more: data mining macro web, www web page create com, webpage problem, webpage i want to create, web page data entry, web page create in html, i want to create web page, first capital, df 15, data processing in data mining, data entry macro, data entry for mines, create id use all web, create a web page html, create a page web, create a com, www web page, create a webpage, telefon, php data mining, paginas, Pac, macro, Macro excel, macro + excel

Project ID: #1349855

12 freelancers are bidding on average $357 for this job

vserv

Pls see your messages. Thanks

$300 USD in 5 days
(60 Reviews)
5.7
mrbrave

Hi...I am experienced in programming such type of macros..See PMB for details...

$300 USD in 4 days
(72 Reviews)
5.3
vbexcel

Data mining pro - ten years experience.

$250 USD in 5 days
(25 Reviews)
5.3
Krusche

We can offer you a reliable bug-free solution with a German quality. Please check your PMB

$300 USD in 4 days
(21 Reviews)
5.2
ineedWorkJob

Greetings sir, i am an expert freelancer. for this job and your 100% satisfaction is assured if you allow me to serve, for more info please cheek your message box for this project(Private)

$250 USD in 5 days
(39 Reviews)
5.1
srinichal

I am an expert in automation and ready to deliver the same

$280 USD in 4 days
(13 Reviews)
4.8
DrTech76

Hi!

$300 USD in 3 days
(27 Reviews)
4.7
petrovp

Good day, I have written the program that downloads the data from the site http://pac.com.ve/paginas-blancas/ At step 1 I downloaded the list of 24 states; At step 2 the list of 418 cities At step 3 I downloaded th More

$250 USD in 3 days
(5 Reviews)
2.5
redscraper

Hi, I'm interested in this job posting, please check PMB. Thanks

$400 USD in 5 days
(3 Reviews)
1.6
amitjamuda

Hi, I am excellent in VBA and multiapplication automation. I am currently engaged with companies like Novartis and Genpact for their office automation requirements. www.novartis.com www.genpact.com I have More

$750 USD in 30 days
(0 Reviews)
0.0
samsgates

I have more exp in web automation

$250 USD in 5 days
(0 Reviews)
0.0
fBGp100

Please Check PMB

$300 USD in 1 day
(0 Reviews)
0.0
shyjasek

i have already done most this types of works

$650 USD in 18 days
(0 Reviews)
0.0