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 ”
cbucher, United States.
Top entries from this contest
-
WesleyJeftha Australia
-
mhaggag89 Egypt
-
ravip121997 Nepal
Public Clarification Board
How to get started with contests
-
Post Your Contest Quick and easy
-
Get Tons of Entries From around the world
-
Award the best entry Download the files - Easy!