Hi there,

Can anyone recommend the best approach to populating a number of form
comboboxes from a single external source?

I had a go at using a short xml file but my xml knowledge is pretty
non-existent. I want to use the same source for another form in Visio as
well as this one in Excel, so I'd rather not use another workbook if I can
help it. Is there a way just iterate through an xml doc to get the data
into Excel?

Cut down version of xml below:

<?xml version="1.0"?>
<ComboFields>
<Measures>
<Measure MeasureItem="miles">
<ID>mil</ID>
</Measure>
<Measure MeasureItem="kilometres">
<ID>klo</ID>
</Measure>
</Measures>
<Elements>
<Element Name="truck">
<ID>trk</ID>
</Element>
<Element Name="motorbike">
<ID>mto</ID>
</Element>
</Elements>
</ComboFields>

All advise welcome!

Best regards

John