Question: how to export access data to excel with template?
Answer: Perfect world: User views report in Access, presses "export" button, data is exported and fills in Excel template, Excel opens to the filled in template, user prompted immediately with "save as" to save as they wish, then template is back sitting empty ready to be filled in again.