Unless I dreamed it up, I know that I have exported multiple queries to a workbook simply using a macro and the TransferSpreadsheet action. Has anyone done this?
I think the 'file name' in the lower left of the macro design view should be something like c:\folder\workbook & worksheet.xls
Maybe...
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.