I would like to export (transfer, copy or the like) multiple access queries to excel. All the queries should be exported to the same file but on different tabs of the spreadsheets. The names of the tabs should be dynamically created based on the name of the query in access. I am by no means an expert, but I can create a module to export the queries and create the tabs of a specific sheet, but it is hardcoded, and I would prefer to only have to enter in the name of the file (FILE.xls) and have the queries exported and the sheets named dynamically. Does anyone have any suggestions of how I can do this?