Ok, I am trying to run a query in VBA, take the data and put it in a new sheet in an excel file. In the end I want to end up with an excel file with multiple sheets with the results from the queries.
I have been looking at createobject() but have had no luck. Any help would be much appreciated.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.