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



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

Skills: Data Entry, Excel, Web Scraping, Web Search

See more: 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

About the Employer:
( 15 reviews ) PARIS, France

Project ID: #4773851

Awarded to:


Please look private message.

€166 EUR in 7 days
(3 Reviews)

14 freelancers are bidding on average €152 for this job


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

€147 EUR in 7 days
(69 Reviews)

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 days
(49 Reviews)

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 days
(25 Reviews)

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

€150 EUR in 7 days
(44 Reviews)

Hi, ready to do this for you!

€247 EUR in 5 days
(41 Reviews)

Thanks for your project. Let's start now.

€155 EUR in 5 days
(20 Reviews)

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 More

€144 EUR in 3 days
(14 Reviews)

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 days
(10 Reviews)

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 More

€147 EUR in 3 days
(4 Reviews)

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 days
(0 Reviews)

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

€226 EUR in 14 days
(0 Reviews)

I am an expert in PPT and Excel.

€122 EUR in 3 days
(0 Reviews)

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

€155 EUR in 3 days
(0 Reviews)