Need web data in excel sheet automatically

[Ali Mian]

Need web data in excel sheet automatically

https://www.zacks.com/stock/quote/AA?q=aa?q=AA

https://www.zacks.com/stock/quote/AA/detailed-estimates

Dear Members

I need to zacks data in excel sheets automatically

Then I need this table data in readable Form

Like from this table

Next Report Date

1/23/18

Current Quarter

1.24

EPS Last Quarter

0.75

Last EPS Surprise

-4.00%

ABR

1.59



The company expects to report next earnings on 1/23/18. Zacks Expert says that the company estimated to report current quarter earnings of 1.24. AA reports earnings of XXXX in last quarter earnings report


I need your help

 

[Ali Mian]

I need Urgent solution therefore posted on these forum also

I posted the same issue on following forum also

https://www.excelforum.com/excel-pr...-word-document-automatically.html#post4799918

https://www.excelguru.ca/forums/sho...an-get-required-data-from-excel-sheet&p=35618

https://www.mrexcel.com/forum/excel...a-code-can-get-required-data-excel-sheet.html