Macro to read<> and </> in rows an produce CSV file

[excelnube]

Hi,

Im trying to create a macro that loops through a number of rows in my spreadsheet (nearly 300).. Reads each rows data, eg:

<..Input..><..Applicant..><..ApplicantIdentifier..>1<../ApplicantIdentifie..r><..Name..><..Title..>MISS<../Title..><..Forename..>ANDREW<../Forename><..MiddleName..>Test<../MiddleName..><..Surname..>RIBENA<../Surname..><../Name...><..Gender..>F<../Gender..><..DateOfBirth..><..CCYY..>1988<../CCYY..><..MM..>1<../MM..><..DD..>26<../DD..><../DateOfBirth..><..FormattedName..>MISSANDREWRIBENA<../FormattedNam..e><../Input..><applicant><applicant><applicant><applicant><applicant>

Minus the .. in the < > i had to add the .. so it would show in this post

Picks out the values between the elements, and produces a CSV file with the values, for example:

1,MISS,ANDREW,TEST,RIBENA,F,1988,1,26,MISSANDREWRIBENA

Any help would be appreciated.

Thanks</applicant></applicant></applicant></applicant></applicant>

 

[excelnube]

Re: Macro to read parse rows an produce CSV file

Not sure why my example row is displayed like that, each element is as per:

<...NAME..>