Hello, and thank you in advance for any advice. I have 22 queries ("FULL_REPORT", "PLANNERS", "NAME_01" through "NAME_20"), to export to Excel from Access 2010. Rather than have the query export as "Name_01", I would like to have it change dynamically to match the worksheet in the same workbook named "Planners", and to match B2. Name_02, would be the same, only B3 and so on through B23. Name_01=B2, Name_02=B3, Name_03=B4 and so on.
I am using a kill command in Access to delete the spreadsheet prior to rebuilding it with Access each day, so I can't use macros within Excel and they would be deleted every day.
Thanks!