Excel data to Word 2007 Userform via DAO

[Colleen]

I have read other posts which describe this procedure and copied the code
from the Word MVP web site
(http://www.word.mvps.org/FAQs/InterDev/FillListBoxFromXLDAO.htm)

I edited the filename to "Book1.xlsx", but unfortunately, I cannot get it to
work. I get the following error:

Run-time error: '3343'

Unrecognized database format 'c:\test\book1.xlsx"

Does this sample not work with Office 2007 files?

Thanks in advance,

 

[Colleen]

I have saved the file as a 97-2003 Excel file and it problem was fixed.