|
code
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
reading a XML file to vb variablesim 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 <snip>> need help > > the xml file can hold any number of pynent details > has anybody any simple code that will read this and assign the values to Add a reference to the MSXML library and use that to parse the XML file, you can then use XPath to retrieve the data you> each section to variables ? require from the document without having to parse any of it yourself. Have a look at this old post and the links from it; should give you plenty of sample code for how to use the library, then come back with any more specific questions. Hope this helps, Mike - Microsoft Visual Basic MVP - E-Mail: ED***@mvps.org WWW: Http://EDais.mvps.org/ "Mike D Sutton" <ED***@mvps.org> wrote in message Uhh, WHAT old post?news:ec1loQsZFHA.3596@tk2msftngp13.phx.gbl... > Have a look at this old post and the links from it; should give you plenty > of > sample code for how to use the library, I bet a twenty (canadian $ though... i'm no rich man <g>) he was talking
about this one : http://groups.google.co.uk/group/microsoft.public.vb.general.discussion/msg/c8f73ad9971fd89 -- Best Regards Yanick > I bet a twenty (canadian $ though... i'm no rich man <g>) he was talking D'oh.. Yes, indeed.. it's been a long day> about this one : > http://groups.google.co.uk/group/microsoft.public.vb.general.discussion/msg/c8f73ad9971fd89 Mike - Microsoft Visual Basic MVP - E-Mail: ED***@mvps.org WWW: Http://EDais.mvps.org/
Creating a DLL and calling it from an app
How to calculate this? Sudden automation error with MS XML object memory leak ? Recent File Parse and preserve an object in a class SP5 to SP6: To update or not? App Protection How do I deploy a VB6 program to folder whose filename has spaces? Problem with multiple forms |
|||||||||||||||||||||||