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.