Hello,
I am looking to export an Access report to an existing Excel workbook using Excel's VBA.
The existing Excel workbook is an .xlsxm file so I am assuming Access would have to export to a .xls file first and then copy contents of the sheet into the .xlsxm file with the macro.
I am not sure where to begin, any assistance would be appreciated.
Thanks.
Bookmarks