Automated Website Data to Excel File - VBA Required
- 状态: Closed
- 奖金: $20
- 参赛作品已收到: 3
- 获胜者: WesleyJeftha
竞赛简介
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
您还可能感兴趣的技能
雇主反馈
“I would recommend everyone to work with Wesley. Great experience and work. Cristobal ”
cbucher, United States.
此竞赛的顶尖作品
-
WesleyJeftha Australia
-
mhaggag89 Egypt
-
ravip121997 Nepal