Thanks for the replies guys! I was able to do it using ADO and some queries
like UglyChicken suggested... but I don't have to import the entire database
every time I want to do it... so I'm happy! Thanks again!


"Allen Geddes" wrote:

I have a bunch of queries in Access that I run daily. I also have an Excel
spreadsheet, and in that spreadsheet, I need to know how many results each
Access Query produced, and put that number in a different cell for each
Access Query.

Right now, I run each query manually, and type the number of records it
produced into my Excel spreadsheet... I'm looking for a way using VBA to
automatically input that number into Excel. Any ideas? Thanks in advance!!