multiple queries into multiple pages in workbook

A

Ashley

I'm trying to create a button in a form (and the underlying code or macro to
make it work) to export two access queries into two worksheets in an excel
workbook. I want the user to be able to determine where the workbook should
be saved. I've tried Output To but this only works with one query.
 
Top