Blammdon1
Board Regular
- Joined
- Jul 11, 2008
- Messages
- 58
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
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