View Single Post
 
Old 06-17-2020, 06:53 AM
jocelyn jocelyn is offline Windows 7 64bit Office 2010
Novice
 
Join Date: Jun 2020
Posts: 2
jocelyn is on a distinguished road
Talking Filling data with XML

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 !
Reply With Quote