Import html source of url list in each cell

[Sergio Alfaro Lloret]

Hi!

How can I import html from url?

Thank you so much for your help! :)

[Excel Fox]

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?

[Sergio Alfaro Lloret]

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! :)

[snb]

cfr. the attachment

[Sergio Alfaro Lloret]

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 :)

[Sergio Alfaro Lloret]

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

[Sergio Alfaro Lloret]

any new here? thanks!

[bakerman]

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

[Sergio Alfaro Lloret]

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