Import html source of url list in each cell

Hi!

How can I import html from url?

Thank you so much for your help! :)

This can be done, but why do you need the entire source code? Are you looking for something specific in the source code? If yes, what?

Hi Excel Fox! thank you so much for your reply.

I need to get te complete source code.

This url have the complete product description, and I will use it for import to my online store this descriptions that are provisioned from my wholesaler in the CSV of the feed of the products. For this reason I need the entire source code, not only something specific.

Thanks again! :)

cfr. the attachment

Hi snb, thanks. I understand that you use the Data-From web, appears a new windows, you write the url and click in import.

I can use this option for two reason:
1- Is not the page source code like you can see in my example
2- The imported text is not in only one cell, use a lot of rows and columns

Thanks again :)

Hi!, can you help me Excel Fox? :)

any new here? thanks!

Code:

---

Sub Test()
    For Each cl In Sheets("Hoja1").Range(Range("E2"), Range("E" & Rows.Count).End(xlUp))
        With CreateObject("MSXML2.XMLHTTP")
            .Open "GET", cl.Value, False
            .Send
            cl.Offset(, 1) = .ResponseText
        End With
    Next
End Sub

---

wow! this works perfect!!! thank you so much bakerman! good work :D