Hi all!
I have access to a website that contains data on companies with a download to excel option. You search an id number or the company name in the site and then you can choose the data points you want and export to excel. Now I have 10s of thousands of these id numbers and am looking to automate this using VBA. I did the first 1000 manually by searching the id number then exporting to excel, copying into my main spreadsheet.
I have a very basic knowledge of VBA but I have used it a bit before. Is this even possible to automate through VBA or am I wasting my time?
So to sum up, I am looking to automatically lookup the id numbers I have saved in excel and pull the data that is exportable from the password protected site back into my main spreadsheet.
Any help would be greatly appreciated!!!
Thanks!
I have access to a website that contains data on companies with a download to excel option. You search an id number or the company name in the site and then you can choose the data points you want and export to excel. Now I have 10s of thousands of these id numbers and am looking to automate this using VBA. I did the first 1000 manually by searching the id number then exporting to excel, copying into my main spreadsheet.
I have a very basic knowledge of VBA but I have used it a bit before. Is this even possible to automate through VBA or am I wasting my time?
So to sum up, I am looking to automatically lookup the id numbers I have saved in excel and pull the data that is exportable from the password protected site back into my main spreadsheet.
Any help would be greatly appreciated!!!
Thanks!
