Please if you could help that would be great.
I have uploaded the excel spreadsheet i am working with. It has a couple example urls to work with from the same site.
I want the links to the website in the excel spreadsheet to be scraped in succession automatically. However I only require one table from each url to be scraped not the whole page. The table i require is the directors table under the website source code: <table class='directors table'> I believe i need to insert that somewhere in the code to only get that table. Please help!
At the moment i have the following issues with the macro:
1. It only scrapes one URL (not all of them in succession)
2. It scrapes the whole page and not solely the directors table
3. It places the scraped data underneath and not next to the url. (in successive cells to the right on the URL)
If you could help modifying this macro to enable it to do these things that would be much appreciated.
Kind Regards,
I have uploaded the excel spreadsheet i am working with. It has a couple example urls to work with from the same site.
I want the links to the website in the excel spreadsheet to be scraped in succession automatically. However I only require one table from each url to be scraped not the whole page. The table i require is the directors table under the website source code: <table class='directors table'> I believe i need to insert that somewhere in the code to only get that table. Please help!
At the moment i have the following issues with the macro:
1. It only scrapes one URL (not all of them in succession)
2. It scrapes the whole page and not solely the directors table
3. It places the scraped data underneath and not next to the url. (in successive cells to the right on the URL)
If you could help modifying this macro to enable it to do these things that would be much appreciated.
Kind Regards,
