access 2010 export report to excel vba

In order to achieve running totals, I have developed a report which nicely displays the data that I am after. I can manually open the report and go through the steps to export the report data to Excel. I can then link to Excel, create a query, and use that for a form or further reporting. Although I can successfully do these steps manually, I need a button/macro or vba commands to do this for users when in a deployed database. Any help is appreciated.

Tried a little harder and found the following to work.

Private Sub cmdRptLabels_Click()
DoCmd.OutputTo acOutputReport, "ReportName", acFormatXLS, "Drive:\Path\FileName.xls", 0
'Keep Excel file closed = 0; to open Excel file automatically = -1

MsgBox "Data has been generated for the labels. Your label report will now open.", vbOKOnly, "Make Labels"
DoCmd.OpenReport "NewReportName_UsingExcelData", acViewPreview, , , acWindowNormal

End Sub

Posting for benefit of others. Thank you for anyone responding.