Concluído

retrieve data from [login to view URL]

The project is written in Visual basic for excel 97 and is delivered as an excel file with all the vba code .

The code must be very simple, using only the methods and properties from the [url removed, login to view] library for VBA.

It consists in retrieving some data from a horse race site named [url removed, login to view]

the race of the date has been entered manually in the A1 cell of sheet1, ex :2013/08/29

the program concatenates the string "[url removed, login to view]" with this date

which provides the url

[url removed, login to view]

displaying a page with all the races of the day,

consisting of several race locations,followed each by several race names.

here we have

lundi : Clairefontaine-Deauville (R1)

1 - Prix Schönbrunn

2 - Prix Matahawk

......

9 - Prix des Glycines

lundi : Rouen-Mauquenchy (R2)

1 - Prix de la Fête du Cheval

.....

etc

in each race name, there is a box containing the string "partants/stats/pro"

which, when clicked on it, provides an url :

for the 1st race this link is:

[url removed, login to view]

1) - the first task is to create an array (n races rows -36 for 2013/07/29-, 3 columns )containing in each row:

col1 : the Race location (ex Clairefontaine-Deauville)

col2 : the race name ( ex Prix Schönbrunn)

col3 : the race url (ex [url removed, login to view])

2)- next task, given an url like the one in col 3 and entered manually in cell A2 of sheet1, is to display in sheet2

some of the data obtained when this url is executed, that is :

horse N°, horse name, url associated with it, jockey name, url associated with it, trainer name, url associated with it

( the associated url is obtained when clicked on the horse, jockey or trainer name)

exemple of such an url:

[url removed, login to view]

So, in sheet2 we must have as many lines as horses in a race, such as this one ( n horses lines and 7 columns):

1 Two Days In Paris horse_url C. Soumillon jockey_url J.-C. Rouget trainer_url

2 Vilacca horse_url [url removed, login to view] jockey_url [url removed, login to view] trainer_url

.......

16 Miss Rail Link horse_url ..................

3)- next task , given an url like one of the 3 displayed above and entered manually in cell A3 of sheet1, is to display

in sheet3 all the dates starting the lines displayed with one such url and the associated url obtained when this date beginning the

line is clicked on it.

So, in sheet3 we must have as many lines as displayed, such as this one ( n date lines and 2 columns):

28/06/13 [url removed, login to view]

17/05/13 [url removed, login to view]

......

there may be sometimes a lot of this lines so their number will be a parameter picked in a constant.

also not that to retrieve all the available lines it is necessary to register, which can be done outside the program:

the login is "sandoz" and the password is "uqwr93ew"

4)- last task, given an url like the one above and entered manually in A4 of sheet1, is to display all the data provided

by this url, USING A WEB QUERY , just as they are provided, without modification.

see attached file for the kind of result

Habilidades: Processamento de Dados, Excel, Captura de dados na web, Busca na Web

Veja mais: www data entry j, string j, starting with visual basic, site web exemple, site de location, sandoz, password vba project excel, named query, exemple de site web, Excel pro, excel jockey, data entry methods, excel 2013 vba, vba project f, retrieve, rail, nantes, jockey, jf, j query

Acerca do Empregador:
( 15 comentários ) PARIS, France

ID do Projeto: #4773851

Concedido a:

belovzorov

Please look private message.

€166 EUR em 7 dias
(3 Comentários)
3.6

14 freelancers estão ofertando em média €152 para esse trabalho

sonarkaushik

Sir, I can do the project. Refer PMB. Looking for further discussions in this matter. with thanks and regards

€147 EUR in 7 dias
(69 Comentários)
5.9
uumairkhalid

Hi.. Expert web scraper/Data Minor here. Interested in your project. I assure you 100% accurate and good quality work. Ready to start. Regards

€157 EUR in 3 dias
(49 Comentários)
5.7
abupabuya

hi sir im an expert in web scrape.. i can scrape that site sir. ive done many scrape project. im very well experienced

€149 EUR in 5 dias
(25 Comentários)
4.9
northwolves

Expert of VBA and data [login to view URL] to start.

€150 EUR in 7 dias
(44 Comentários)
4.9
fhasanbd

Hi, ready to do this for you!

€247 EUR in 5 dias
(41 Comentários)
4.6
flashsaiful

Thanks for your project. Let's start now.

€155 EUR in 5 dias
(20 Comentários)
3.6
jkumarsanson

Hello sir, I am kindly interested in this type of project works I will perfectly finish the work within the stipulated time kindly give me an offer to work for you I expect your cordial relationship in the due course Mais

€144 EUR in 3 dias
(14 Comentários)
3.3
Shohagmax

Hello sir, I'm interested to do this job. I have experience for doing this job. Please check PMB for details. Regards. Shohag

€133 EUR in 7 dias
(10 Comentários)
3.2
MasterExcel

I am Data Entry Expert, MS Word and MS Excel. i am very much professional in this work i am pretty sure that you cant find a best person for this job like me so i am ready to work on your project with low rate and high Mais

€147 EUR in 3 dias
(4 Comentários)
2.5
nasir01719466902

Dear project manager, I read your job descriptions and I am very interested to work on your project. Please see my PM.

€34 EUR in 7 dias
(0 Comentários)
0.0
dinotech

understood ur requirement and ready to start................

€226 EUR in 14 dias
(0 Comentários)
0.0
amber400

I am an expert in PPT and Excel.

€122 EUR in 3 dias
(0 Comentários)
0.0
josephine4142j

hi, please contact me anytime. I have high experience in this kind of job:-)

€155 EUR in 3 dias
(0 Comentários)
1.6