I can provide you python script not VBA
these are my skills set related to web
scraping
Have done scraping in Nodejs, CasperJS Phantomjs, python scrapy
Have done testing and automation with selenium also.
Know to deal with database like mongo, mysql, Elasticsearch.
Also know to handle proxy and captcha while scrapping.