Quote Originally Posted by robnjay
Nate:

I am an old-timer with VB, although very rusty now. In fact, I was very flattered to find my name mentioned in Mr. McKinney's book you reference above. I've written some very involved VBA in Excel, several add-ins, but I am really lost with regard to ADO & database queries, etc.
I had to pull my pointer reference as my response was a little confusing, but a great read!

Quote Originally Posted by robnjay
I just don't want to have to carry around an mdb file or write to a temporary range in the open workbook.
I think you have to pass the first recordset to a worksheet, preferably the one which holds your second RS table. Now you have one table which you can query against. Using screen updating, you can do this behind the scenes. This gives you your DB which you can connect to. I can't picture one connecting to a RS object burned in memory.