Populate combobox from external source
 

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"
<IDmil</ID
</Measure
<Measure MeasureItem="kilometres"
<IDklo</ID
</Measure
</Measures
<Elements
<Element Name="truck"
<IDtrk</ID
</Element
<Element Name="motorbike"
<IDmto</ID
</Element
</Elements
</ComboFields

All advise welcome!

Best regards

John