Access 2007 Macro for Excel Export

How do I create a macro that will export two queries into one excel file but on different sheets. If not by Macro then what will work?

Who is Participating?
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
just do something like this:

DoCmd.TransferSpreadsheet acExport, , "qry1", "c:\YourFolder\2Files.xls"
DoCmd.TransferSpreadsheet acExport, , "qry2", "c:\YourFolder\2Files.xls"
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.