Thanks Sam and Paul for the examples.

Does it make any sense to create 2 classes and create objects for every item(they are unique) and create objects for each location(if not already created). If they used a few of the same properties then they would have a relationship, and the logic would be easier? I dont know. what do you think.


Loop....

dim i as string
i = element.offset(0,2)
dim i as new myItem
with i
.type
.location
.section
end with

dim x as string
x= element.offset(0,5)
dim x as new myLocations
with x
. location
. section
. etc....
end with

Would something like this work?