HI,
To my experience, vba is not the best option for the script for scrapping large number of pages.
Excel will hang up for hour and may terminate the operation.
.Net based advanced tools or other scripting is the solution, which will export the data in Excel format.
If we have a chat, I will discuss more with you in detail about how it will work.
The page loading data through dynamically and not the static ones, so we need to talk on this issue too for the solution.
Looking for your reply.'
Thanks