HTML data in excel VBA

[lulupatel]

Dear Sir

can anybody help me to extract data from URL...

is there any VBA code, I can get Data in to excel....

look into Image.. which data I need

Web.jpg

here is the URL

thanks in advance

[AB33]

I helped you on your last thread, but you did not bother to acknowledge and this kind of attitude does not bode well with me.
I will give you some clue though. You know how to loop through a table as you did on last thread, but instead of getting inner text, you do href. For each child(Element) inner text, you now do child.href, not child.innertext

[lulupatel]

Sorry Sir AB33

for my last thread.. even I did not acknowledge. its truly my fault. I should replay and thankful when I am learning something...

I am sorry

sir Actually I am not a programmer. I am just working as in Diamond jewelry Marketing company but to make my work easy I just getting help from various people like you. so thanks to advise me

best regards
Lalit Patel

[AB33]

When you post a thread next time, please attach a sample excel book, not a picture. It is not clear from the picture if you just want to extract the link or the entire TR. Try the attached. If this is not what you wanted, you need to show me on a sample with attachment your desired result.