MS Access export to Excel template
Posted on 2013-05-31
I would be very grateful if someone could help me with the following.
I have an Excel workbook with several worksheets and VBA. I would like to export data from various tables in an Access database to the Excel workbook.
Is there an equivalent of the Workbook.SaveAs method in Excel that I can use in Access? Effectively, I would like to open the Excel workbook as a template and save the updated version with a different filename?
Many thanks in advance