Vba: importing in Excel a table in file txt

[Nelson78]

Hello everybody.

In the path

C:\Users\john.smith\Desktop\filetext

I’ve a file txt that contains, substantially, a table.

Inside you can see a canonical html language (columns and rows separated by th tr td …).


How can I import it in Excel via Vba?


Thank’s in advance.

 

[ranman256]

have you tried:
menu: Data , From Text (on the get external data tab)?

 

[Nelson78]

Yes: it doesn't seem possible.

 

[Nelson78]

Nothing to do: I've tried to import separating for < or /
Probably in this case the biggest problem is all the document is imported in one row.

 

[Nelson78]

I can substitute < /td > < td > with ; to create the columns for importing in Excel, but I don't know how to deal with a new line (substitute < /tr > < tr > with what?)