Using VBA, how do you extract author and date information from a news URL. For example, in column A I have a list of URLs and I want to extract and paste author name of these news articles to column B (adjacent to each article), and date in Column C. Sample URLs are as follows:
https://www.latimes.com/california/s...pped-raped-her
Column A
https://www.latimes.com/world-nation...ts-to-migrants
https://www.nytimes.com/2019/04/04/w...a-burundi.html
https://www.aljazeera.com/news/2018/...062552098.html
Column B
Alejandra Reyes-Velarde
Patrick J. McDonnell
Milan Schreuer
None
Column C
09/16/2019
09/02/2019
04/04/2019
11/21/2018
Any help would be appreciated