@DbColumn lookup from embedded Excel Workbook
Posted on 2004-10-06
I would like create a Dialog List field (field name: DktDest). The field choices will be obtained by doing an @DbColumn lookup using data from a form-embedded Excell Workbook. The embedded Workbook is named "Datakit Worksheet", the worksheet is titled "Alpha Dest" the column is "Dkt Dest" (Column A). In my efforts to make this work, I tried referencing a "named range" (this range is named "DktDestProp") in the embedded spreadsheet, but was still unsucessful!