VBA code that can get required data from excel sheet

[alialimian12]

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
[TABLE="width: 195"]
<tbody>[TR]
[TD]Next Report Date
[/TD]
[TD]1/23/18
[/TD]
[/TR]
[TR]
[TD]Current Quarter
[/TD]
[TD]1.24
[/TD]
[/TR]
[TR]
[TD]EPS Last Quarter
[/TD]
[TD]0.75
[/TD]
[/TR]
[TR]
[TD]Last EPS Surprise
[/TD]
[TD]-4.00%
[/TD]
[/TR]
[TR]
[TD]ABR
[/TD]
[TD]1.59
[/TD]
[/TR]
</tbody>[/TABLE]


I want not all values from above table. I need some values that are explained in below paragraph
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

 

[Macropod]

Cross-posted at:
https://www.excelforum.com/excel-pr...el-sheet-and-word-document-automatically.html
https://www.excelguru.ca/forums/sho...e-that-can-get-required-data-from-excel-sheet

Please read Mr Excel's policy on Cross-Posting in rule 13: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html

 

[alialimian12]

Sorry Now i mentioned the cross posting
I posted the same issue on following forum also
I need Urgent solution therefore posted on these forum also
https://chandoo.org/forum/threads/need-web-data-in-excel-sheet-automatically.36656/
https://www.excelforum.com/excel-pr...-word-document-automatically.html#post4799918