reading an xml file into variables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

im runninb vb6 sp6

im having to read a xml file from a third party to update our records and
need help

the xml file can hold any number of pynent details

<SubmissionResults xmlns="http://bacs.co.uk/submissions"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

submissionIdentifier="1117541180734CcTf5MW0i"
status="complete"
submissionType="fullTest"
submissionSerialNumber="000045"
submissionDateAndTime="Tue May 31 13:06:30 BST 2005"
submissionEarliestDate="2005-06-01">





<SubmittingServiceUser
userNumber="B40107"
name="A NAMED BUREAU LTD"/>

<SubmittingContact contactIdentifier="NAME123456"
fullName="MR ANY NAME" />

<SigningContact contactIdentifier="NAME123456"
fullName="MR ANY NAME"/>


<PaymentFile status="complete"
index="1"
paymentFileIdentifier="001"

processingDay="2005-06-01"
currency="GBP"
creditRecordCount="0"
creditValueTotal="0"
debitRecordCount="0"
debitValueTotal="0"
ddiRecordCount="2"
workCode="1 DAILY ">






<OriginatingServiceUser userNumber="090909"
name="A NAMED ENTERPRISE LIMITED"/>

</PaymentFile>

<PaymentFile status="complete"
index="2"
paymentFileIdentifier="001"

processingDay="2005-06-01"
currency="GBP"
creditRecordCount="0"
creditValueTotal="0"
debitRecordCount="19"
debitValueTotal="150984"
ddiRecordCount="0"
workCode="1 DAILY ">




<OriginatingServiceUser userNumber="121212"
name="A PRIVATE COMPANY"/>

</PaymentFile>

</SubmissionResults>

has anybody any simple code that will read this and assign the values to
each section to variables ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top