Hello Everyone
One of your well-known members "Worf" has helped me with a web scraping process, which is performed to grab data on msn.com stocks.
The challenge here: Excel copies and paste the data, then stop and highlight an error:
Cells(i, 4) = driver.FindElementByXPath("//*[@id=""root""]/div[1]/div/div[5]/div/div/div[2]/div/div[2]/div[2]/div[8]/div[2]").Text
As Wolf is not available... How can I get past this?
Here is the excel file: Workbook
Please forgive me. If you watch the 15 second video, Click Here I am having problems with continuing the process.
The error on: Cells(i, 4) = driver.FindElementByXPath("//*[@id=""root""]/div[1]/div/div[5]/div/div/div[2]/div/div[2]/div[2]/div[8]/div[2]").Text
Only the column "A" & "B" gets filled. After that. The macro stops.
Any help to point me in the right direction...
Thanks again
Cheers
One of your well-known members "Worf" has helped me with a web scraping process, which is performed to grab data on msn.com stocks.
The challenge here: Excel copies and paste the data, then stop and highlight an error:
Cells(i, 4) = driver.FindElementByXPath("//*[@id=""root""]/div[1]/div/div[5]/div/div/div[2]/div/div[2]/div[2]/div[8]/div[2]").Text
As Wolf is not available... How can I get past this?
Here is the excel file: Workbook
Please forgive me. If you watch the 15 second video, Click Here I am having problems with continuing the process.
The error on: Cells(i, 4) = driver.FindElementByXPath("//*[@id=""root""]/div[1]/div/div[5]/div/div/div[2]/div/div[2]/div[2]/div[8]/div[2]").Text
Only the column "A" & "B" gets filled. After that. The macro stops.
Any help to point me in the right direction...
Thanks again
Cheers