Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: resullivan
- Order by date
-
Excel VBA: Access to Excel
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.- resullivan
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel VBA: Access to Excel
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.- resullivan
- Thread
- Replies: 4
- Forum: VBA Visual Basic for Applications (Microsoft)
