Parsing XML from text file

Hi,

I have exported some windows event logs which has created a text file. This is a mixture of text and XML.
I am looking for a way to go through the text file and extract the XML whilst ignoring the plain text. I would then like to take each line of XML data and place it into a a row of its own. Essentially creating a new row for each event within the log.

I have attached the event log output and also a spreadsheet that shows how I would like it to look. I've done this manually, but I want to export around 100 logs and can't go through it manually for that many.

Thanks

Hi !

What a weird file format !

Anyway, at beginner level :

• Read each line from text file using Line Input # statement,
to see in VBA inner help and its sample showing how to read a text file …

• Use Like operator to check each line.

• Extract data via VBA basics text functions like Split or Instr & Mid …