Help with automated queries

[Blammdon1]

I tried recording a macro to find how to automate a query but that didn't work very well... Is there a way to edit a query for one item and then copy the results of that query onto another spread sheet and then re-do the whole process about 20 more times all inside a macro?

All i really would like is a decent site or explanation on how to use/manipulate queries in VBA. I have a connenction string and everything i need to connect i just don't know how to do it/edit it in VBA