Tuma Shindano

Automated Website Data to Excel File - VBA Required

Hali: Closed
Zawadi: $20
Wasilisho Zilizopokelewa: 3
Mshindi: WesleyJeftha

Winner

Maelezo ya Shindano

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

Ujuzi unaopendekezwa

Winner

Tuma Shindano kama Hili

Maoni ya Muajiri

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

cbucher, United States.

Wasilisho kuu kwenye hili shindano

WesleyJeftha Australia

0
mhaggag89 Egypt

0
ravip121997 Nepal

0

Bodi ya Ufafanuzi ya Umma

hsashankar
- Miaka 6 iliyopita
#increaseprize
- Miaka 6 iliyopita
javiercocu
- Miaka 6 iliyopita
why VBA? I can do it in python
- Miaka 6 iliyopita
javiercocu
- Miaka 6 iliyopita
#increaseprize
- Miaka 6 iliyopita
Kulfi Softwares
- Miaka 6 iliyopita
#increaseprize #increaseprize
- Miaka 6 iliyopita