Filling data with XML

jocelyn · #1 06-17-2020, 06:53 AM

Hello,

I'm stuck starting a development VBA Macro for Word.
I want to know the best approach for this dev:

1 - I want to fill some data in a word file. These data type can be a scalar value, an image (and maybe later a table).

2 - All data are stored in an XML file, like this one :

Code:

<?xml version="1.0" encoding="UTF-8"?>
<results>
    <result version="1.0">
        <scalar name="x" value="789" unit="mm" id="0010214"/>
        <vector name="v" value="0,1,2,3,4,5" id="6164201"/>
        <image name="graph" path="img/v1/graph.png" id="5431054"/>
    </result>

    <result version="2.0">
        <scalar name="x" value="450" unit="mm" id="0010214"/>
        <vector name="v" value="8,8,2,3,7,5" id="6164201"/>
        <image name="graph" path="img/v2/graph.png" id="5431054"/>
    </result>
 </results>

3 - The tricky part for me is to properly link a data with an XML node. Because I want to update all data with the last version result.

4 - Every data is more complicate than just a value (unit, etc.). It will be absolutely perfect to store an associated VBA Object....

Thanks for helping me to find the best direction !

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Filling in cells based on 2 other cells data	Dawindle	Excel	4	11-10-2018 07:40 AM
filling in blank cells with data from cell above	RayK	Excel	1	01-12-2017 04:14 PM
Wierd... "cell" started auto filling with data from other cells I double click on. How stop it?!	KerryOn	Excel	2	08-10-2015 08:41 PM
matching data from one work sheet to another, then auto filling missing cell information	timomaha	Excel	1	09-12-2014 07:51 AM
New to Excel - Filling out data	The Accountant	Excel	2	12-16-2013 12:32 PM