Create an Excel application to gather informations from an internet site
- Status: Closed
- Prize: $30
- Entries Received: 1
- Winner: hiten247
Contest Brief
Preparations:
log into this site https://www.spontacts.com/account/sign_in
with these informations:
salifakbar@gmx.net
salifakbar
Now, you have access to the sites of all the users in the format
https://www.spontacts.com/users/#
where # corresponds to a user's number.
For example, for user number 10, it would be:
https://www.spontacts.com/users/10
When you open exactly this user page, you find
these informations:
_______________________________
Alexander E.
https://static.spontacts.com/grid/avatars/abb36677-aba4-4b85-bb62-1b40f511cc09-large.jpg (user's picture)
Alter: 39
Geschlecht: Mann
Beziehungsstatus: Single
1000 km entfernt von dir
_______________________________
Two values on the excel sheet need to define the range of users (number #) to be scanned, e.g. from 1 to 1000
After clicking a button, a macro should generate a list with all the gathered informations:
1 (number #) | Alexander E. | https://.....jpg (picture as a hyperlink) | Geschlecht: Mann | ... | ...
2 | ... | ... | ... | ... | ...
3 | ... | ... | ... | ... | ...
The picture needs to be stored in a directory, given in another cell of the excel sheet.
The first who creates a program which does exactly this, wins.
Recommended Skills
Employer Feedback
“Fast and professional. Great job!”
Tobiaszu, Switzerland.
Public Clarification Board
How to get started with contests
-
Post Your Contest Quick and easy
-
Get Tons of Entries From around the world
-
Award the best entry Download the files - Easy!