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 I am missing quotes somewhere?
I think the 'file name' in the lower left of the macro design view should be something like c:\folder\workbook & worksheet.xls
Maybe I am missing quotes somewhere?
