Really stumped here. I've managed to scrape a website's results page (Insurance eligibility) and get some results I want and dump it into my Excel file....except for one.
I've tried numerous variations of the getelementbyid/classname/
This is my current code which isn't working, and yes, I am giving the page time to load:
I need the correct vba to scrape this page, find the message "COVERAGE WILL END ON 02/29/2016...." and put it in the indicated cell on the worksheet.
I've tried numerous variations of the getelementbyid/classname/
This is my current code which isn't working, and yes, I am giving the page time to load:
Code:
sht.Cells(j, 5).value = ie.document.getelementbyid("MevsCoveredServices1_lblTerminationMessage")(0).innertext
I need the correct vba to scrape this page, find the message "COVERAGE WILL END ON 02/29/2016...." and put it in the indicated cell on the worksheet.