Create an Excel application to gather informations from an internet site
- Status: Closed
- Prize: $30
- Entries Received: 1
- Winner: hiten247
log into this site https://www.spontacts.com/account/sign_in
with these informations:
Now, you have access to the sites of all the users in the format
where # corresponds to a user's number.
For example, for user number 10, it would be:
When you open exactly this user page, you find
https://static.spontacts.com/grid/avatars/abb36677-aba4-4b85-bb62-1b40f511cc09-large.jpg (user's picture)
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.
“Fast and professional. Great job!”
Top entries from this contest