Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Populate Drop-Down Content Control from CustomXMLPart added to the Document
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 05-11-2016, 01:10 PM
KhmerBoi1 KhmerBoi1 is offline Populate Drop-Down Content Control from CustomXMLPart added to the Document Windows 7 64bit Populate Drop-Down Content Control from CustomXMLPart added to the Document Office 2010 64bit
Novice
Populate Drop-Down Content Control from CustomXMLPart added to the Document 		 
Join Date: May 2016
Posts: 2
KhmerBoi1 is on a distinguished road
Default Populate Drop-Down Content Control from CustomXMLPart added to the Document
Microsoft Word 2010 Document with Drop-Down Content Control Added as the first content control. It has a title and tag of "Unit Selection". I would like to add a CustomXMLPart to the Word Document and populate the Drop-Down with all the site elements from the CustomXMLPart. Attached are all the documents.

Below is the code for the XML file:
Code:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<SitesTable xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="C:/Users/troy.pilewski/Desktop/CSI/SiteListSchema.xsd">
<!--A list of United States Naval Ships-->
    <SiteRow>
        <site hull="CCSG-1">COMCARSTRKGRU ONE</site>
    </SiteRow>
    <SiteRow>
        <site hull="BXR">COMPHIBRON ONE</site>
    </SiteRow>
    <SiteRow>
        <site hull="ARC1">MT EMPIRE STATE</site>
    </SiteRow>
    <SiteRow>
        <site hull="AOT5205">MT EVERGREEN STATE</site>
    </SiteRow>
    <SiteRow>
        <site hull="AK 4396">MV BERNARD F FISHER</site>
    </SiteRow>
    <SiteRow>
        <site hull="AK4543">MV LTC JOHN U D PAGE</site>
    </SiteRow>
    <SiteRow>
        <site hull="AK4544">MV SSG EDWARD A CARTER JR</site>
    </SiteRow>
    <SiteRow>
        <site hull="AK323">MV TSGT JOHN A CHAPMAN</site>
    </SiteRow>
    <SiteRow>
        <site hull="SBX 1">Sea-Based X-Band Radar</site>
    </SiteRow>
    <SiteRow>
        <site hull="AK5065">SS CAPE MOHICAN</site>
    </SiteRow>
    <SiteRow>
        <site hull="AVB4">SS CURTISS</site>
    </SiteRow>
    <SiteRow>
        <site hull="AK 3015">USNS 1ST HARRY L MARTIN</site>
    </SiteRow>
    <SiteRow>
        <site hull="AK 3010">USNS 1ST LT BALDOMERO LOPEZ</site>
    </SiteRow>
    <SiteRow>
        <site hull="AK 3011">USNS 1ST LT JACK LUMMUS</site>
    </SiteRow>
    <SiteRow>
        <site hull="AK 3008">USNS 2ND LT JOHN P BOBO</site>
    </SiteRow>
    <SiteRow>
        <site hull="AGOS 20">USNS ABLE</site>
    </SiteRow>
    <SiteRow>
        <site hull="AKE 3">USNS ALAN SHEPARD</site>
    </SiteRow>
    <SiteRow>
        <site hull="AKE 6">USNS AMELIA EARHART</site>
    </SiteRow>
    <SiteRow>
        <site hull="ATF 172">USNS APACHE</site>
    </SiteRow>
    <SiteRow>
        <site hull="AOE 8">USNS ARCTIC</site>
    </SiteRow>
    <SiteRow>
        <site hull="AKR 306">USNS BENAVIDEZ</site>
    </SiteRow>
    <SiteRow>
        <site hull="AO 198">USNS BIG HORN</site>
    </SiteRow>
    <SiteRow>
        <site hull="AKR 300">USNS BOB HOPE</site>
    </SiteRow>
    <SiteRow>
        <site hull="AGS 62">USNS BOWDITCH</site>
    </SiteRow>
    <SiteRow>
        <site hull="AOE 10">USNS BRIDGE</site>
    </SiteRow>
    <SiteRow>
        <site hull="AKR 305">USNS BRITTIN</site>
    </SiteRow>
    <SiteRow>
        <site hull="AGS 64">USNS BRUCE C HEEZEN</site>
    </SiteRow>
    <SiteRow>
        <site hull="AKR293">USNS CAPELLA</site>
    </SiteRow>
    <SiteRow>
        <site hull="AKE 7">USNS CARL BRASHEAR</site>
    </SiteRow>
    <SiteRow>
        <site hull="ATF 168">USNS CATAWBA</site>
    </SiteRow>
    <SiteRow>
        <site hull="AKE 14">USNS CESAR CHAVEZ</site>
    </SiteRow>
    <SiteRow>
        <site hull="AKE 10">USNS CHARLES DREW</site>
    </SiteRow>
    <SiteRow>
        <site hull="AKR 314">USNS CHARLTON</site>
    </SiteRow>
    <SiteRow>
        <site hull="JHSV 2">USNS CHOCTAW COUNTY</site>
    </SiteRow>
    <SiteRow>
        <site hull="T-AH 20">USNS COMFORT</site>
    </SiteRow>
    <SiteRow>
        <site hull="AKR 312">USNS DAHL</site>
    </SiteRow>
    <SiteRow>
        <site hull="AGOS 21">USNS EFFECTIVE</site>
    </SiteRow>
    <SiteRow>
        <site hull="JHSV 4">USNS FALL RIVER</site>
    </SiteRow>
    <SiteRow>
        <site hull="AKR 301">USNS FISHER</site>
    </SiteRow>
    <SiteRow>
        <site hull="AKR 298">USNS GILLILAND</site>
    </SiteRow>
    <SiteRow>
        <site hull="AKR 296">USNS GORDON</site>
    </SiteRow>
    <SiteRow>
        <site hull="ARS 53">USNS GRAPPLE</site>
    </SiteRow>
    <SiteRow>
        <site hull="ARS 51">USNS GRASP</site>
    </SiteRow>
    <SiteRow>
        <site hull="AO 200">USNS GUADALUPE</site>
    </SiteRow>
    <SiteRow>
        <site hull="HST 1">USNS GUAM</site>
    </SiteRow>
    <SiteRow>
        <site hull="AK 3017">USNS GYSGT FRED W STOCKHAM</site>
    </SiteRow>
    <SiteRow>
        <site hull="AO 187">USNS HENRY J KAISER</site>
    </SiteRow>
    <SiteRow>
        <site hull="AGS 63">USNS HENSON</site>
    </SiteRow>
    <SiteRow>
        <site hull="AGM 25">USNS HOWARD O LORENZEN</site>
    </SiteRow>
    <SiteRow>
        <site hull="AGOS 23">USNS IMPECCABLE</site>
    </SiteRow>
    <SiteRow>
        <site hull="AGM 24">USNS INVINCIBLE</site>
    </SiteRow>
    <SiteRow>
        <site hull="AO 194">USNS JOHN ERICSSON</site>
    </SiteRow>
    <SiteRow>
        <site hull="MLP 2">USNS JOHN GLENN</site>
    </SiteRow>
    <SiteRow>
        <site hull="AO 189">USNS JOHN LENTHALL</site>
    </SiteRow>
    <SiteRow>
        <site hull="AO 188">USNS JOSHUA HUMPHREYS</site>
    </SiteRow>
    <SiteRow>
        <site hull="AO 196">USNS KANAWHA</site>
    </SiteRow>
    <SiteRow>
        <site hull="AO 203">USNS LARAMIE</site>
    </SiteRow>
    <SiteRow>
        <site hull="T-AOT 1125">USNS LAWRENCE H GIANELLA</site>
    </SiteRow>
    <SiteRow>
        <site hull="AK 3016">USNS LCPL ROY M WHEAT</site>
    </SiteRow>
    <SiteRow>
        <site hull="AO 195">USNS LEROY GRUMMAN</site>
    </SiteRow>
    <SiteRow>
        <site hull="AKE 1">USNS LEWIS &amp;amp; CLARK</site>
    </SiteRow>
    <SiteRow>
        <site hull="MLP3AFSB">USNS LEWIS B PULLER</site>
    </SiteRow>
    <SiteRow>
        <site hull="T-AGOS 22">USNS LOYAL</site>
    </SiteRow>
    <SiteRow>
        <site hull="AK 3007">USNS MAJ STEPHEN W PLESS</site>
    </SiteRow>
    <SiteRow>
        <site hull="SP-312">USNS MARK SCHROEDER</site>
    </SiteRow>
    <SiteRow>
        <site hull="AGS 65">USNS MARY SEARS</site>
    </SiteRow>
    <SiteRow>
        <site hull="AKE 9">USNS MATTHEW PERRY</site>
    </SiteRow>
    <SiteRow>
        <site hull="AKE 13">USNS MEDGAR EVERS</site>
    </SiteRow>
    <SiteRow>
        <site hull="AKR 303">USNS MENDONCA</site>
    </SiteRow>
    <SiteRow>
        <site hull="T-AH19">USNS MERCY</site>
    </SiteRow>
    <SiteRow>
        <site hull="JHSV 3">USNS MILLINOCKET</site>
    </SiteRow>
    <SiteRow>
        <site hull="MLP1">USNS MONTFORD POINT</site>
    </SiteRow>
    <SiteRow>
        <site hull="ATF 169">USNS NAVAJO</site>
    </SiteRow>
    <SiteRow>
        <site hull="AGS 60">USNS PATHFINDER</site>
    </SiteRow>
    <SiteRow>
        <site hull="AO 201">USNS PATUXENT</site>
    </SiteRow>
    <SiteRow>
        <site hull="AO 197">USNS PECOS</site>
    </SiteRow>
    <SiteRow>
        <site hull="AK 3009">USNS PFC DEWAYNE T WILLIAMS</site>
    </SiteRow>
    <SiteRow>
        <site hull="AK 3006">USNS PFC EUGENE A OBREGON</site>
    </SiteRow>
    <SiteRow>
        <site hull="AKR 304">USNS PILILAAU</site>
    </SiteRow>
    <SiteRow>
        <site hull="AKR 316">USNS POMEROY</site>
    </SiteRow>
    <SiteRow>
        <site hull="TSV 1">USNS PREVAIL</site>
    </SiteRow>
    <SiteRow>
        <site hull="HST 2">USNS PUERTO RICO</site>
    </SiteRow>
    <SiteRow>
        <site hull="AOE 7">USNS RAINIER</site>
    </SiteRow>
    <SiteRow>
        <site hull="AO 204">USNS RAPPAHANNOCK</site>
    </SiteRow>
    <SiteRow>
        <site hull="AKR 313">USNS RED CLOUD</site>
    </SiteRow>
    <SiteRow>
        <site hull="AKE 4">USNS RICHARD E BYRD</site>
    </SiteRow>
    <SiteRow>
        <site hull="AKE 5">USNS ROBERT E PEARY</site>
    </SiteRow>
    <SiteRow>
        <site hull="AKE 2">USNS SACAGAWEA</site>
    </SiteRow>
    <SiteRow>
        <site hull="ARS 50">USNS SAFEGUARD</site>
    </SiteRow>
    <SiteRow>
        <site hull="ARS 52">USNS SALVOR</site>
    </SiteRow>
    <SiteRow>
        <site hull="AKR 302">USNS SEAY</site>
    </SiteRow>
    <SiteRow>
        <site hull="AK 3005">USNS SGT MATEJ KOCAK</site>
    </SiteRow>
    <SiteRow>
        <site hull="AK 3012">USNS SGT WILLIAM R BUTTON</site>
    </SiteRow>
    <SiteRow>
        <site hull="AKR 295">USNS SHUGHART</site>
    </SiteRow>
    <SiteRow>
        <site hull="ATF 171">USNS SIOUX</site>
    </SiteRow>
    <SiteRow>
        <site hull="AKR 311">USNS SISLER</site>
    </SiteRow>
    <SiteRow>
        <site hull="AKR 317">USNS SODERMAN</site>
    </SiteRow>
    <SiteRow>
        <site hull="JHSV 1">USNS SPEARHEAD</site>
    </SiteRow>
    <SiteRow>
        <site hull="AGS 61">USNS SUMNER</site>
    </SiteRow>
    <SiteRow>
        <site hull="AOE 6">USNS SUPPLY</site>
    </SiteRow>
    <SiteRow>
        <site hull="AO 199">USNS TIPPECANOE</site>
    </SiteRow>
    <SiteRow>
        <site hull="JHSV 5">USNS TRENTON</site>
    </SiteRow>
    <SiteRow>
        <site hull="AG5001">USNS VADM K R WHEELER</site>
    </SiteRow>
    <SiteRow>
        <site hull="AGOS 19">USNS VICTORIOUS</site>
    </SiteRow>
    <SiteRow>
        <site hull="AKE 8">USNS WALLY SCHIRRA</site>
    </SiteRow>
    <SiteRow>
        <site hull="AO 193">USNS WALTER S DIEHL</site>
    </SiteRow>
    <SiteRow>
        <site hull="AKE 11">USNS WASHINGTON CHAMBERS</site>
    </SiteRow>
    <SiteRow>
        <site hull="AGS 45">USNS WATERS</site>
    </SiteRow>
    <SiteRow>
        <site hull="AKR 315">USNS WATKINS</site>
    </SiteRow>
    <SiteRow>
        <site hull="AKR 310">USNS WATSON</site>
    </SiteRow>
    <SiteRow>
        <site hull="AKE 12">USNS WILLIAM MCLEAN</site>
    </SiteRow>
    <SiteRow>
        <site hull="AKR 297">USNS YANO</site>
    </SiteRow>
    <SiteRow>
        <site hull="AO 202">USNS YUKON</site>
    </SiteRow>
    <SiteRow>
        <site hull="ARC 7">USNS ZEUS</site>
    </SiteRow>
    <SiteRow>
        <site hull="CVN 72">USS ABRAHAM LINCOLN</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSBN 731">USS ALABAMA</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSBN 732">USS ALASKA</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 753">USS ALBANY</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 706">USS ALBUQUERQUE</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 757">USS ALEXANDRIA</site>
    </SiteRow>
    <SiteRow>
        <site hull="LHA 6">USS AMERICA</site>
    </SiteRow>
    <SiteRow>
        <site hull="LPD 23">USS ANCHORAGE</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 760">USS ANNAPOLIS</site>
    </SiteRow>
    <SiteRow>
        <site hull="CG 54">USS ANTIETAM</site>
    </SiteRow>
    <SiteRow>
        <site hull="CG 68">USS ANZIO</site>
    </SiteRow>
    <SiteRow>
        <site hull="MCM 12">USS ARDENT</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 51">USS ARLEIGH BURKE</site>
    </SiteRow>
    <SiteRow>
        <site hull="LPD 24">USS ARLINGTON</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 758">USS ASHEVILLE</site>
    </SiteRow>
    <SiteRow>
        <site hull="LSD 48">USS ASHLAND</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 96">USS BAINBRIDGE</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 52">USS BARRY</site>
    </SiteRow>
    <SiteRow>
        <site hull="LHD 5">USS BATAAN</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 65">USS BENFOLD</site>
    </SiteRow>
    <SiteRow>
        <site hull="LCC 19">USS BLUE RIDGE</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 764">USS BOISE</site>
    </SiteRow>
    <SiteRow>
        <site hull="LHD 6">USS BONHOMME RICHARD</site>
    </SiteRow>
    <SiteRow>
        <site hull="LHD 4">USS BOXER</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 698">USS BREMERTON</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 715">USS BUFFALO</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 84">USS BULKELEY</site>
    </SiteRow>
    <SiteRow>
        <site hull="CG 52">USS BUNKER HILL</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 781">USS CALIFORNIA</site>
    </SiteRow>
    <SiteRow>
        <site hull="CG 71">USS CAPE ST GEORGE</site>
    </SiteRow>
    <SiteRow>
        <site hull="CVN 70">USS CARL VINSON</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 64">USS CARNEY</site>
    </SiteRow>
    <SiteRow>
        <site hull="LSD 50">USS CARTER HALL</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 90">USS CHAFEE</site>
    </SiteRow>
    <SiteRow>
        <site hull="MCM 4">USS CHAMPION</site>
    </SiteRow>
    <SiteRow>
        <site hull="CG 62">USS CHANCELLORSVILLE</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 766">USS CHARLOTTE</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 773">USS CHEYENNE</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 721">USS CHICAGO</site>
    </SiteRow>
    <SiteRow>
        <site hull="MCM 14">USS CHIEF</site>
    </SiteRow>
    <SiteRow>
        <site hull="PC 9">USS CHINOOK</site>
    </SiteRow>
    <SiteRow>
        <site hull="CG 65">USS CHOSIN</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 93">USS CHUNG HOON</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 705">USS CITY OF CORPUS CHRISTI</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 67">USS COLE</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 788">USS COLORADO</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 771">USS COLUMBIA</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 762">USS COLUMBUS</site>
    </SiteRow>
    <SiteRow>
        <site hull="LSD 45">USS COMSTOCK</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 22">USS CONNECTICUT</site>
    </SiteRow>
    <SiteRow>
        <site hull="LCS 4">USS CORONADO</site>
    </SiteRow>
    <SiteRow>
        <site hull="CG 63">USS COWPENS</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 54">USS CURTIS WILBUR</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 700">USS DALLAS</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 73">USS DECATUR</site>
    </SiteRow>
    <SiteRow>
        <site hull="MCM 6">USS DEVASTATOR</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 105">USS DEWEY</site>
    </SiteRow>
    <SiteRow>
        <site hull="MCM 13">USS DEXTROUS</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 75">USS DONALD COOK</site>
    </SiteRow>
    <SiteRow>
        <site hull="CVN 69">USS DWIGHT D EISENHOWER</site>
    </SiteRow>
    <SiteRow>
        <site hull="AS 39">USS EMORY S LAND</site>
    </SiteRow>
    <SiteRow>
        <site hull="LHD 2">USS ESSEX</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 99">USS FARRAGUT</site>
    </SiteRow>
    <SiteRow>
        <site hull="PC 10">USS FIREBOLT</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 62">USS FITZGERALD</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSGN 728">USS FLORIDA</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 98">USS FORREST SHERMAN</site>
    </SiteRow>
    <SiteRow>
        <site hull="LSD 43">USS FORT MCHENRY</site>
    </SiteRow>
    <SiteRow>
        <site hull="LCS 3">USS FORT WORTH</site>
    </SiteRow>
    <SiteRow>
        <site hull="AS 40">USS FRANK CABLE</site>
    </SiteRow>
    <SiteRow>
        <site hull="LCS 1">USS FREEDOM</site>
    </SiteRow>
    <SiteRow>
        <site hull="FFG 51">USS GARY</site>
    </SiteRow>
    <SiteRow>
        <site hull="CVN 77">USS GEORGE H W BUSH</site>
    </SiteRow>
    <SiteRow>
        <site hull="CVN 73">USS GEORGE WASHINGTON</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSGN 729">USS GEORGIA</site>
    </SiteRow>
    <SiteRow>
        <site hull="CVN 78">USS GERALD R FORD</site>
    </SiteRow>
    <SiteRow>
        <site hull="LSD 42">USS GERMANTOWN</site>
    </SiteRow>
    <SiteRow>
        <site hull="CG 64">USS GETTYSBURG</site>
    </SiteRow>
    <SiteRow>
        <site hull="MCM 11">USS GLADIATOR</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 66">USS GONZALEZ</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 107">USS GRAVELY</site>
    </SiteRow>
    <SiteRow>
        <site hull="LPD 20">USS GREEN BAY</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 772">USS GREENEVILLE</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 101">USS GRIDLEY</site>
    </SiteRow>
    <SiteRow>
        <site hull="LSD 44">USS GUNSTON HALL</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 97">USS HALSEY</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 767">USS HAMPTON</site>
    </SiteRow>
    <SiteRow>
        <site hull="LSD 49">USS HARPERS FERRY</site>
    </SiteRow>
    <SiteRow>
        <site hull="CVN 75">USS HARRY S TRUMAN</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 768">USS HARTFORD</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 776">USS HAWAII</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 725">USS HELENA</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSBN 730">USS HENRY M JACKSON</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 76">USS HIGGINS</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 70">USS HOPPER</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 713">USS HOUSTON</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 83">USS HOWARD</site>
    </SiteRow>
    <SiteRow>
        <site hull="CG 66">USS HUE CITY</site>
    </SiteRow>
    <SiteRow>
        <site hull="PC 3">USS HURRICANE</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 786">USS ILLINOIS</site>
    </SiteRow>
    <SiteRow>
        <site hull="LCS 2">USS INDEPENDENCE</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 789">USS INDIANA</site>
    </SiteRow>
    <SiteRow>
        <site hull="LHD 7">USS IWO JIMA</site>
    </SiteRow>
    <SiteRow>
        <site hull="LCS 6">USS JACKSON</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 699">USS JACKSONVILLE</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 95">USS JAMES E WILLIAMS</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 109">USS JASON DUNHAM</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 759">USS JEFFERSON CITY</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 23">USS JIMMY CARTER</site>
    </SiteRow>
    <SiteRow>
        <site hull="CVN 74">USS JOHN C STENNIS</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 53">USS JOHN PAUL JONES</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 56">USS JOHN S MCCAIN</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 785">USS JOHN WARNER</site>
    </SiteRow>
    <SiteRow>
        <site hull="LHD 3">USS KEARSARGE</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSBN 737">USS KENTUCKY</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 722">USS KEY WEST</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 100">USS KIDD</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 701">USS LA JOLLA</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 58">USS LABOON</site>
    </SiteRow>
    <SiteRow>
        <site hull="CG 57">USS LAKE CHAMPLAIN</site>
    </SiteRow>
    <SiteRow>
        <site hull="CG 70">USS LAKE ERIE</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 82">USS LASSEN</site>
    </SiteRow>
    <SiteRow>
        <site hull="CG 55">USS LEYTE GULF</site>
    </SiteRow>
    <SiteRow>
        <site hull="LCS 9">USS LITTLE ROCK</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSBN 743">USS LOUISIANA</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 724">USS LOUISVILLE</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 72">USS MAHAN</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSBN 741">USS MAINE</site>
    </SiteRow>
    <SiteRow>
        <site hull="LHD 8">USS MAKIN ISLAND</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSBN 738">USS MARYLAND</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 87">USS MASON</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 85">USS MCCAMPBELL</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 74">USS MCFAUL</site>
    </SiteRow>
    <SiteRow>
        <site hull="LPD 19">USS MESA VERDE</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 1001">USS MICHAEL MONSOOR</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 112">USS MICHAEL MURPHY</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSGN 727">USS MICHIGAN</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 69">USS MILIUS</site>
    </SiteRow>
    <SiteRow>
        <site hull="LCS 5">USS MILWAUKEE</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 783">USS MINNESOTA</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 782">USS MISSISSIPPI</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 780">USS MISSOURI</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 57">USS MITSCHER</site>
    </SiteRow>
    <SiteRow>
        <site hull="CG 53">USS MOBILE BAY</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 92">USS MOMSEN</site>
    </SiteRow>
    <SiteRow>
        <site hull="PC 4">USS MONSOON</site>
    </SiteRow>
    <SiteRow>
        <site hull="CG 61">USS MONTEREY</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 765">USS MONTPELIER</site>
    </SiteRow>
    <SiteRow>
        <site hull="LCC 20">USS MOUNT WHITNEY</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 89">USS MUSTIN</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSBN 739">USS NEBRASKA</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSBN 733">USS NEVADA</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 778">USS NEW HAMPSHIRE</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 779">USS NEW MEXICO</site>
    </SiteRow>
    <SiteRow>
        <site hull="LPD 18">USS NEW ORLEANS</site>
    </SiteRow>
    <SiteRow>
        <site hull="LPD 21">USS NEW YORK</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 750">USS NEWPORT NEWS</site>
    </SiteRow>
    <SiteRow>
        <site hull="CVN 68">USS NIMITZ</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 94">USS NITZE</site>
    </SiteRow>
    <SiteRow>
        <site hull="CG 60">USS NORMANDY</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 777">USS NORTH CAROLINA</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 784">USS NORTH DAKOTA</site>
    </SiteRow>
    <SiteRow>
        <site hull="LSD 51">USS OAK HILL</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSGN 726">USS OHIO</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 77">USS O'KANE</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 723">USS OKLAHOMA CITY</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 717">USS OLYMPIA</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 79">USS OSCAR AUSTIN</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 752">USS PASADENA</site>
    </SiteRow>
    <SiteRow>
        <site hull="MCM 7">USS PATRIOT</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 60">USS PAUL HAMILTON</site>
    </SiteRow>
    <SiteRow>
        <site hull="LSD 52">USS PEARL HARBOR</site>
    </SiteRow>
    <SiteRow>
        <site hull="LHA 5">USS PELELIU</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSBN 735">USS PENNSYLVANIA</site>
    </SiteRow>
    <SiteRow>
        <site hull="CG 58">USS PHILIPPINE SEA</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 91">USS PINCKNEY</site>
    </SiteRow>
    <SiteRow>
        <site hull="MCM 9">USS PIONEER</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 720">USS PITTSBURGH</site>
    </SiteRow>
    <SiteRow>
        <site hull="AFSB 15">USS PONCE</site>
    </SiteRow>
    <SiteRow>
        <site hull="CG 73">USS PORT ROYAL</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 78">USS PORTER</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 88">USS PREBLE</site>
    </SiteRow>
    <SiteRow>
        <site hull="CG 59">USS PRINCETON</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 719">USS PROVIDENCE</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 61">USS RAMAGE</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSBN 740">USS RHODE ISLAND</site>
    </SiteRow>
    <SiteRow>
        <site hull="CVN 76">USS RONALD REAGAN</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 80">USS ROOSEVELT</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 71">USS ROSS</site>
    </SiteRow>
    <SiteRow>
        <site hull="LSD 47">USS RUSHMORE</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 59">USS RUSSELL</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 102">USS SAMPSON</site>
    </SiteRow>
    <SiteRow>
        <site hull="LPD 17">USS SAN ANTONIO</site>
    </SiteRow>
    <SiteRow>
        <site hull="LPD 22">USS SAN DIEGO</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 711">USS SAN FRANCISCO</site>
    </SiteRow>
    <SiteRow>
        <site hull="CG 56">USS SAN JACINTO</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 751">USS SAN JUAN</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 763">USS SANTA FE</site>
    </SiteRow>
    <SiteRow>
        <site hull="MCM 8">USS SCOUT</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 756">USS SCRANTON</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 21">USS SEAWOLF</site>
    </SiteRow>
    <SiteRow>
        <site hull="MCM 3">USS SENTRY</site>
    </SiteRow>
    <SiteRow>
        <site hull="PC 13">USS SHAMAL</site>
    </SiteRow>
    <SiteRow>
        <site hull="CG 67">USS SHILOH</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 86">USS SHOUP</site>
    </SiteRow>
    <SiteRow>
        <site hull="PC 6">USS SIROCCO</site>
    </SiteRow>
    <SiteRow>
        <site hull="LPD 25">USS SOMERSET</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 790">USS SOUTH DAKOTA</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 761">USS SPRINGFIELD</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 111">USS SPRUANCE</site>
    </SiteRow>
    <SiteRow>
        <site hull="PC 7">USS SQUALL</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 104">USS STERETT</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 63">USS STETHEM</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 106">USS STOCKDALE</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 55">USS STOUT</site>
    </SiteRow>
    <SiteRow>
        <site hull="PC 2">USS TEMPEST</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSBN 734">USS TENNESSEE</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 775">USS TEXAS</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 68">USS THE SULLIVANS</site>
    </SiteRow>
    <SiteRow>
        <site hull="CVN 71">USS THEODORE ROOSEVELT</site>
    </SiteRow>
    <SiteRow>
        <site hull="PC 12">USS THUNDERBOLT</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 769">USS TOLEDO</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 754">USS TOPEKA</site>
    </SiteRow>
    <SiteRow>
        <site hull="PC 14">USS TORNADO</site>
    </SiteRow>
    <SiteRow>
        <site hull="LSD 46">USS TORTUGA</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 103">USS TRUXTUN</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 770">USS TUCSON</site>
    </SiteRow>
    <SiteRow>
        <site hull="PC 5">USS TYPHOON</site>
    </SiteRow>
    <SiteRow>
        <site hull="CG 72">USS VELLA GULF</site>
    </SiteRow>
    <SiteRow>
        <site hull="CG 69">USS VICKSBURG</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 774">USS VIRGINIA</site>
    </SiteRow>
    <SiteRow>
        <site hull="MCM 10">USS WARRIOR</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSN 787">USS WASHINGTON</site>
    </SiteRow>
    <SiteRow>
        <site hull="LHD 1">USS WASP</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 108">USS WAYNE E MEYER</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSBN 736">USS WEST VIRGINIA</site>
    </SiteRow>
    <SiteRow>
        <site hull="LSD 41">USS WHIDBEY ISLAND</site>
    </SiteRow>
    <SiteRow>
        <site hull="PC 11">USS WHIRLWIND</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 110">USS WILLIAM P LAWRENCE</site>
    </SiteRow>
    <SiteRow>
        <site hull="DDG 81">USS WINSTON S CHURCHILL</site>
    </SiteRow>
    <SiteRow>
        <site hull="SSBN 742">USS WYOMING</site>
    </SiteRow>
    <SiteRow>
        <site hull="PC 8">USS ZEPHYR</site>
    </SiteRow>
</SitesTable>
Below is the schema for the XML File:


Code:
<xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema">
    <xs:element name="SitesTable">
        <xs:complexType>
            <xs:sequence>
                <xs:element name="SiteRow" maxOccurs="unbounded" minOccurs="0">
                    <xs:complexType>
                        <xs:sequence>
                            <xs:element name="site">
                                <xs:complexType>
                                    <xs:simpleContent>
                                        <xs:extension base="xs:string">
                                            <xs:attribute type="xs:string" name="hull" use="optional"/>
                                        </xs:extension>
                                    </xs:simpleContent>
                                </xs:complexType>
                            </xs:element>
                        </xs:sequence>
                    </xs:complexType>
                </xs:element>
            </xs:sequence>
        </xs:complexType>
    </xs:element>
</xs:schema>
Below is the VBA code I used:
Code:
Sub ReadCustomXML()
On Error GoTo ErrorReadCustomXMLInfo
 
'Declares variables
Dim XMLNameSpace        As String
Dim XMLNameSpaceCustom  As String
Dim XMLNameSpacePrefix  As String
 
Dim XMLParts            As CustomXMLParts
Dim XMLPart             As CustomXMLPart
 
Dim XMLSiteNodes        As CustomXMLNodes
Dim XMLSiteNode         As CustomXMLNode
Dim XMLHullNodes        As CustomXMLNodes
Dim XMLHullNode         As CustomXMLNode
 
Dim i                   As Integer
Dim strXPath            As String
Dim ListItemEntry       As String
Dim objXMLMapping       As XMLMapping
 
 
'Set the Documents-Level CustomXMLParts
Set XMLParts = ThisDocument.CustomXMLParts
Debug.Print XMLParts.Count
 
If XMLParts.Count > 4 Then
    For Each XMLPart In XMLParts
        'Deletes the CustomXMLPart
        CustomXMLParts.SelectByNamespace("").item(1).Delete
    Next XMLPart
    'Adds a CustomXMLPart to the Document
    CustomXMLParts.Add
    'Loads the CustomXMLPart with data from a XML File
    CustomXMLParts(CustomXMLParts.Count).Load ("C:\Users\troy.pilewski\Desktop\CSI\SiteList.xml")
    For Each XMLPart In XMLParts
        XMLNameSpace = XMLPart.NamespaceURI
        If Len(XMLNameSpace) = 0 Then
            Set XMLSiteNodes = XMLPart.SelectNodes("/SitesTable/SiteRow/site")
            If XMLSiteNodes.Count > 0 Then
                For Each XMLSiteNode In XMLSiteNodes
'                    Debug.Print XMLSiteNode.Text & " (" & XMLSiteNode.Attributes.item(1).Text & ")"
                    ListItemEntry = XMLSiteNode.Text & " (" & XMLSiteNode.Attributes.item(1).Text & ")"
                    Debug.Print ListItemEntry
                    With ActiveDocument.ContentControls(1).DropdownListEntries
                        .Add ListItemEntry
                    End With
                Next XMLSiteNode
            End If
        End If
    Next XMLPart
ElseIf XMLParts.Count = 4 Then
    For Each XMLPart In XMLParts
        'Deletes the CustomXMLPart
        CustomXMLParts.SelectByNamespace("").item(1).Delete
    Next XMLPart
    'Adds a CustomXMLPart to the Document
    CustomXMLParts.Add
    'Loads the CustomXMLPart with data from a XML File
    CustomXMLParts(CustomXMLParts.Count).Load ("C:\Users\troy.pilewski\Desktop\CSI\SiteList.xml")
    For Each XMLPart In XMLParts
        XMLNameSpace = XMLPart.NamespaceURI
        If Len(XMLNameSpace) = 0 Then
            Set XMLSiteNodes = XMLPart.SelectNodes("/SitesTable/SiteRow/site")
            If XMLSiteNodes.Count > 0 Then
                For Each XMLSiteNode In XMLSiteNodes
'                    Debug.Print XMLSiteNode.Text & " (" & XMLSiteNode.Attributes.item(1).Text & ")"
                    ListItemEntry = XMLSiteNode.Text & " (" & XMLSiteNode.Attributes.item(1).Text & ")"
                    Debug.Print ListItemEntry
                    With ActiveDocument.ContentControls(1).DropdownListEntries
                        .Add ListItemEntry
                    End With
                Next XMLSiteNode
            End If
        End If
    Next XMLPart
Else
    'Adds a CustomXMLPart to the Document
    CustomXMLParts.Add
    'Loads the CustomXMLPart with data from a XML File
    CustomXMLParts(CustomXMLParts.Count).Load ("C:\Users\troy.pilewski\Desktop\CSI\SiteList.xml")
    For Each XMLPart In XMLParts
        XMLNameSpace = XMLPart.NamespaceURI
        If Len(XMLNameSpace) = 0 Then
            Set XMLSiteNodes = XMLPart.SelectNodes("/SitesTable/SiteRow/site")
                For Each XMLSiteNode In XMLSiteNodes
'                    Debug.Print XMLSiteNode.Text & " (" & XMLSiteNode.Attributes.item(1).Text & ")"
                    ListItemEntry = XMLSiteNode.Text & " (" & XMLSiteNode.Attributes.item(1).Text & ")"
                    Debug.Print ListItemEntry
                    With ActiveDocument.ContentControls(1).DropdownListEntries
                        .Add ListItemEntry
                    End With
                Next XMLSiteNode
        End If
    Next XMLPart
End If
 
 
ErrorReadCustomXMLInfo:
 
End Sub
Attached Files
File Type: docm Cyber Security Inspection Outlook.docm (110.4 KB, 16 views)
File Type: zip SiteList.zip (3.9 KB, 10 views)
Last edited by KhmerBoi1; 05-12-2016 at 08:15 AM. Reason: Fix the formatting of the schema
Reply With Quote
Reply

Tags
word 2010, xml in ms word, xml mapping

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Populate Drop-Down Content Control from CustomXMLPart added to the Document Is there a way to anchor drop-down content control boxes so entering text doesn't change formatting? TzarChasm Word 7 04-14-2016 06:28 PM
Have Text Entered in Content Control / PreDefined Field Populate Field in Footer bzowk Word 1 04-14-2016 11:50 AM
Word drop-down content control dependent display issue vvcat Word 6 02-03-2015 11:20 PM
Word 2010 Content Control help - Combo Boxes vs Drop Down List proghy Word 1 09-16-2014 02:01 PM
Populate Drop-Down Content Control from CustomXMLPart added to the Document Deleting a table from a content control -- preserving the content control BrainSlugs83 Word Tables 8 11-14-2013 03:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:38 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft