vba code to parse xml file
looking for some vba coding to parse thru an xml file, need to extract : the following fields:Vendor FirmID and Name,UserID,lastname,first
New to XML and lost as where to begin
CEM_PLI2.xml
Clipboard01.jpg
New to XML and lost as where to begin
CEM_PLI2.xml
Clipboard01.jpg
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
@ste5an:
I wouldn't set a reference, as it is a major source of troubles, but use late binding instead.
Plus you're retrieving data from the 1st user only, and missing credit détails.
@durick:
You'll find an object oriented approach in the workbook attached below, see the test() procedure in the test module.
It isn't completed yet tho, as I'm still waiting for your answer about credit and credit details data.
EE.xlsm
I wouldn't set a reference, as it is a major source of troubles, but use late binding instead.
Plus you're retrieving data from the 1st user only, and missing credit détails.
@durick:
You'll find an object oriented approach in the workbook attached below, see the test() procedure in the test module.
It isn't completed yet tho, as I'm still waiting for your answer about credit and credit details data.
EE.xlsm
It was just a sample, not ment to be complete.. and while development I use always early binding. IntelliSense, you know ;)
Wich datas do you need from credits and creditDetails ?
I can offer a solution but you need to elaborate.