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!
-
Going from an Access database to Excel Using a Macro?
Guys - Thanks for the help. I'll try the live links and multiple queries. Actually, you gave me an idea. I may just try to read the original table that contains my key (group #) and possibly run the query with multiple cases based on each group number. Again, thanks for the help.- jbin99
- Post #13
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Going from an Access database to Excel Using a Macro?
ETID, I'm building this into the context of an automated Access DB. The process requires no manual intervention. Is it possible to automate the excel live link to the query that you are talking about using Access VBA?- jbin99
- Post #10
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Going from an Access database to Excel Using a Macro?
Guys - I noticed your conversation here and also have questions about exporting a query from access to excel. I have used the Docmd.OutputTo, which works fine for exporting an entire query to a specific file. I am having a problem figuring out how to sort and export the query by a variable...- jbin99
- Post #8
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Saving... I don't think so but ==> how no to???
Big - Try me.dirty.Close False (without the =)- jbin99
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
