Hi I'm new to VBA, mostly used MatLab and some Python (very limited),

So at my job I was given a task of finding missing information from a company website. I need to find information such as where the employee works (building name), their first name, last name, and region of location. The only information i was provided by was their email.

What im trying to do:
I have 853 emails in excel in Column A.
I want to use VBA to open IE to the company website, enter the email from A2 and search.
Then once the information is found, to take the certain fields (from the website) and populate it back into excel Columns B,C,D,etc. to fill in their names, locations etc.

And i need this to loop until all the information for all the employees is entered.

currently my code only gets to IE, sometimes... [once i figure out how to post the code on here ill post below]

Is this even possible for VBA?



The company uses IE8 on windows 7. I upgraded to IE11 and now I'm having a "certificate verification" issue.