Linking WORD Cascading Dropdown Boxes to Excel

[music_al]

Hi

I have 3 drop down boxes on a Word form. Lets call them DD1, DD2 and DD3

The selection of DD1 determines the List Items in DD2 and the selection of DD2 determines the List Items of DD3.

At the moment this is hard coded into a Word module but I would prefer to use ranges of cells in Excel that can be maintained by the users.



I was thinking of having a Worksheet for each list and the Worksheet name be the same as the item selected.

So, if someone selects "Fresh Fruit" from DD1, this would populate DD2 with the list that is in the Worksheet called "Fresh Fruit".

If someone then selects "Variety of Apples" from DD2 (the "Fresh Fruit" list), this would would then populate DD3 with the list in the "Variety of Apples" Worksheet.

I know how to use RowCount and loop functions to use the 'ListEntries.Add' function, but I'm just not sure how to reference the Excel Workbook in the first place. I don't want the Workbook to open, just to be referenced.

Any help would be appreciated.