swaggerbox
09-20-2019, 05:05 AM
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:
Column A
https://www.latimes.com/california/story/2019-09-16/traffic-stop-passenger-tells-deputies-driver-kidnapped-raped-her
https://www.latimes.com/world-nation/story/2019-09-01/kidnapping-of-pastor-in-mexican-border-town-dramatizes-threats-to-migrants
https://www.nytimes.com/2019/04/04/world/europe/belgium-kidnapping-congo-rwanda-burundi.html
https://www.aljazeera.com/news/2018/11/kenya-gunmen-kidnap-italian-woman-wound-coast-181121062552098.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
Column A
https://www.latimes.com/california/story/2019-09-16/traffic-stop-passenger-tells-deputies-driver-kidnapped-raped-her
https://www.latimes.com/world-nation/story/2019-09-01/kidnapping-of-pastor-in-mexican-border-town-dramatizes-threats-to-migrants
https://www.nytimes.com/2019/04/04/world/europe/belgium-kidnapping-congo-rwanda-burundi.html
https://www.aljazeera.com/news/2018/11/kenya-gunmen-kidnap-italian-woman-wound-coast-181121062552098.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