Exporting an Access Report to Excel

I need to take a report that I have created in Microsoft Access and send it to Excel. The problem that I have is that some of the data on the report is created using VBA and there are groupings and totals on the report that don’t come out like I want them. Is there a way to capture all of these things and format them to an Excel Spreadsheet.