Fix VBA code to scrape each company's owner name, address, phone number, etc
Budget: $8 – $15 CAD
https://chbabc.org/find-a-member/page/2/
This is the website I want to apply the VBA to scrape the above info. I already set up the code. In the for loop, the first line works perfectly, but the second line which is supposed to scrape the owner's name doesn't work. Please fix that line and in the for loop, write similar lines to scrape the address, phone number and the rest of info.
This is the website I want to apply the VBA to scrape the above info. I already set up the code. In the for loop, the first line works perfectly, but the second line which is supposed to scrape the owner's name doesn't work. Please fix that line and in the for loop, write similar lines to scrape the address, phone number and the rest of info.