Ignore my other posting. I managed to give myself a shove instead.
Turns out I didn't have DAO loaded (Yes, DAO - the client is using Excel 97). I now have a recordset and have scanned through the fields picking up the names as a test.
Many thanks for your help,