Create an Excel application to gather informations from an internet site

Status: Closed
Prize: $30
Entries Received: 1
Winner: hiten247

Winner

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

Winner

Post a Contest Like This

Employer Feedback

“Fast and professional. Great job!”

Tobiaszu, Switzerland.

Public Clarification Board

hiten247
- 7 years ago
hi...working on it right now.,,
- 7 years ago
Pulpe
- 7 years ago
Working on it
- 7 years ago
Contest Holder
- 7 years ago
No, I need it with Excel. Sorry.
- 7 years ago
vlayausa
- 7 years ago
Would it be okay if this was done using iMacros?
- 7 years ago
Contest Holder
- 7 years ago
# will be a variable in the macro and needs to be counted up.
- 7 years ago
Contest Holder
- 7 years ago
replace the # by a number
- 7 years ago
Contest Holder
- 7 years ago
I checked the first link again. Here, it works. First, you have to sign in at th page https:....../account/sign_in and then you can access the user pages like the example https:....../users/10.
- 7 years ago
Imperturbable54
- 7 years ago
Could you please give a correct link as this says http://prntscr.com/b335m8
- 7 years ago
Phihong113
- 7 years ago
I great in Excel and now my main job is Teacher about Excel. I am very interesting in collect the information.i 'm not affraid difficulty job but i need good detail about it
- 7 years ago