I am working on a user form attached to a Word template. I want to populate a combo box in this form and use an excel spreadsheet for the combo box’s rowsource. I’ve got Word and Excel nodding to each other by referencing the Excel Object library and then
Dim mySpreadsheet as Excel.Workbook
Set mySpreadsheet = GetObject(“G:\...\all 10 11.xls”)

Yes, I’m working with Word 2003 & Excel 2003.
It’s the next line that’s been giving me problems. I’ve tried naming the range in the spreadsheet and then referring to the named range. I’ve tried referring to cells A2:A300. Either way I keep on getting error number 9 (subscript out of range), or 424 (object required). (Assume the combobox is called cmbID, the named range is called ID_Nos, and the sheet it is on is called 10 11 summary.)
Can someone please help me with the syntax?
Thank you