Create an Excel application to gather informations from an internet site

Estado: Closed
Premio: $30
Propuestas recibidas: 1
Ganador: hiten247

Winner

Resumen del concurso

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.

Habilidades recomendadas

Winner

Publica un concurso similar

Comentarios del empleador

“Fast and professional. Great job!”

Tobiaszu, Switzerland.

Tablero de aclaración pública

hiten247
- 7 años atrás
hi...working on it right now.,,
- 7 años atrás
Pulpe
- 7 años atrás
Working on it
- 7 años atrás
Organizador del concurso
- 7 años atrás
No, I need it with Excel. Sorry.
- 7 años atrás
vlayausa
- 7 años atrás
Would it be okay if this was done using iMacros?
- 7 años atrás
Organizador del concurso
- 7 años atrás
# will be a variable in the macro and needs to be counted up.
- 7 años atrás
Organizador del concurso
- 7 años atrás
replace the # by a number
- 7 años atrás
Organizador del concurso
- 7 años atrás
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 años atrás
Imperturbable54
- 7 años atrás
Could you please give a correct link as this says http://prntscr.com/b335m8
- 7 años atrás
Phihong113
- 7 años atrás
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 años atrás