Having done my best to read and understand the references, plus various MS Articles on the topic (eg,. kb/150418 and kb/108146) I have not been able to get any code to work for me.

Since this thread started on the topic of Excel and, thanks to your help, that part has been resolved I will mark it as Resolved and start a new thread about the Access query.

Thank you all,

camoore

Wales, UK