1. Can you run a query in excel without the query already existing in the access file? I want to specify what the query is in the vba script.
2. If so give me a keyword to search for that will help me run a query in excel from the access file.
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.