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 [login to view URL]
with these informations:
salifakbar@[login to view URL]
salifakbar

Now, you have access to the sites of all the users in the format
[login to view URL]
where # corresponds to a user's number.

For example, for user number 10, it would be:
[login to view URL]

When you open exactly this user page, you find
these informations:
_______________________________
Alexander E.
[login to view URL] (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!”

Profile image Tobiaszu, Switzerland.

Top entries from this contest

View More Entries

Public Clarification Board

  • hiten247
    hiten247
    • 4 years ago

    hi...working on it right now.,,

    • 4 years ago
  • Pulpe
    Pulpe
    • 4 years ago

    Working on it

    • 4 years ago
  • Tobiaszu
    Contest Holder
    • 4 years ago

    No, I need it with Excel. Sorry.

    • 4 years ago
  • vlayausa
    vlayausa
    • 4 years ago

    Would it be okay if this was done using iMacros?

    • 4 years ago
  • Tobiaszu
    Contest Holder
    • 4 years ago

    # will be a variable in the macro and needs to be counted up.

    • 4 years ago
  • Tobiaszu
    Contest Holder
    • 4 years ago

    replace the # by a number

    • 4 years ago
  • Tobiaszu
    Contest Holder
    • 4 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.

    • 4 years ago
  • Imperturbable54
    Imperturbable54
    • 4 years ago

    Could you please give a correct link as this says http://prntscr.com/b335m8

    • 4 years ago
  • Phihong113
    Phihong113
    • 4 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

    • 4 years ago

Show more comments

How to get started with contests

  • Post your contest

    Post Your Contest Quick and easy

  • Get tons of entries

    Get Tons of Entries From around the world

  • Award the best entry

    Award the best entry Download the files - Easy!

Post a Contest Now or Join us Today!