Im having trouble developing a macro that parses an export very particularly



I have attached an example of two Sheets

Of what the raw code looks like and how I want it parsed

I have only provided an example for a part of it! the other needs to be filled out.

Ive been trying to do this my self but with no luck!

Thanks!

Cross Post:
http://www.excelforum.com/showthread...t=#post4386328
http://www.mrexcel.com/forum/excel-q...ml#post4521068

Attached Files

Parsing Example 2.xlsm (244.9 KB, 9 views)

Interesting!

Q1: Why (in the first example) is the description for S0 "N/A" instead of "Abort Start"?

Q2: Did the second example in your attachment fail? I see no relationship between the second example's raw code and its parsing.

This looks moderately complicated, but I see no reason we can't walk you through it so that you'll be able to write the code and understand how it works.

I think for this you're going to need to create a few simple classes and group them together into Collections. Do you already know how to do that?