Hi Kelly - sorry to hijack your thread, but I have to know...
when you say:
> ADO (have used this with Access)
how did you do this? If you can tell me how you did this in access with
ADO (which ive never been able to do) Im pretty sure I can adopt the
approach to excel?
thanks
Glenn