I can do it with VB code no problem... but maybe this might be easier,  How do I transfer the result not only into a listbox rowsource BUT to an excel spreadsheet... TransferSpreadsheet acExport function   Ultimately this is my problem

---

Reply from Alex Hedley:

You can use QueryDefs to create a Query on the fly.
Did you try the * trick for ALL?


Create a String of where you want to save it to and the name:
strExcelFile
Choose the correct 'SpreadsheetType'

expression .TransferSpreadsheet(TransferType, SpreadsheetType, TableName, FileName, HasFieldNames, Range, UseOA)

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "QUERYNAME", strExcelFile, True
https://msdn.microsoft.com/en-us/library/office/ff844793.aspx

AcSpreadSheetType Enumeration (Access)
https://msdn.microsoft.com/en-us/library/office/ff196017.aspx