Hi all,
Looking for assistance here with getting this done in XML. I need to find a quick and VBA-free (macros are disabled by default on project) method for populating a series of comboboxes and then (hopefully) make them dynamic of each other.
Originally this used to be an Access db and a series of forms (on a similair project) but they've now phased out access. Which wouldn't be a problem with Office 19/365 as I could use the dynamic arrays features in excel... Unfortunately they're using a mix of Office 13/16.
Basically the three combos represent a different column in a table and the tables is approx ~50 lines deep. And the form will be based off aprrox 10-15 similiar sized tables.
Me being too lazy to manually populate each CC, I had hoped that I could pull these lists into the CC via a custom XML Add-in.
I had thought either of the two would work... but the xml doesn't bind to the CC
Code:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<!--<xmlns="Data Scaveneger"/>-->
<DataScavenge>
<Common>
<UniqueID></UniqueID>
<systemName>
<item>
<system>Air Conditioning</system>
<system>Cooling Water</system>
<system>Cold Water</system>
<system>Hot Water</system>
</item>
</systemName>
<pscName>
<psc>AirCon</psc>
<psc>CoolWtr</psc>
<psc>CldWtr</psc>
<psc>HotWtr</psc>
</pscName>
<TSC></TSC>
</Common>
<Section1></Section1>
</DataScavenge>