Automated Website Data to Excel File - VBA Required

  • Status: Closed
  • Prize: $20
  • Entries Received: 3
  • Winner: WesleyJeftha

Contest Brief

Hi all,

I need someone to code on Visual Basic (VBA) a module that goes to a link, copy the information of the each page in different columns of an excel file.
https://www.portalinmobiliario.com/arriendo/departamento/providencia-metropolitana?ca=3&ts=1&mn=2&or=&sf=0&sp=0&at=0&pg=2

The page is specified after pg=*, so for the previous example the link will direct you to the second page. Following the same logic, the link for the page number 35 would be:

https://www.portalinmobiliario.com/arriendo/departamento/providencia-metropolitana?ca=3&ts=1&mn=2&or=&sf=0&sp=0&at=0&pg=35

I need that the code will repeat for each page of the website until it fills all the columns of the excel file.

Attached you will find an example of the output wanted which was retrieved manually.

Thank you!

Cristobal

Recommended Skills

Employer Feedback

“I would recommend everyone to work with Wesley. Great experience and work. Cristobal ”

Profile image cbucher, United States.

Top entries from this contest

View More Entries

Public Clarification Board

  • hsashankar
    hsashankar
    • 6 years ago

    #increaseprize

    • 6 years ago
  • javiercocu
    javiercocu
    • 6 years ago

    why VBA? I can do it in python

    • 6 years ago
  • javiercocu
    javiercocu
    • 6 years ago

    #increaseprize

    • 6 years ago
  • Kulfi Softwares
    Kulfi Softwares
    • 6 years ago

    #increaseprize #increaseprize

    • 6 years ago

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!