How to extract rss bing results with VBA

[satish78]

Hi Friends,

In sheet2 ColumnA with below RSS urls.

Need to extract all results from each url into sheet1 like title, description, url, date.

http://www.bing.com/search?q= site:Plus.google.com site:Plus.google.com "lived in * dallas" "carpernter at" about&qs=&format=rss&count=50

http://www.bing.com/search?q= site:Plus.google.com site:Plus.google.com "lived in * dallas" "plumber at" about&qs=&format=rss&count=50

http://www.bing.com/search?q= site:Plus.google.com site:Plus.google.com "lived in * dallas" "cashier at" about&qs=&format=rss&count=50

Can anyone help me with VBA macro to complete this task?.

Thanks
Satish