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 ?
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 ?