Export Access 2010 Web Report into Excel

[lodhi1978]

Hi All,

I am using Access 2010, I have made web forms and web reports, Now I want to export the web report data to excel file,
I use below subroutine

Sub Test()

    Dim outReportData As String
    Dim xlFileName As String

    outReportData = "rpt-Cities-Completed-2011"
    xlFileName = "C:\Documents and Settings\haneyr\My Documents\Test.xls"

    DoCmd.OutputTo acOutputReport, outReportData, acFormatXLS, xlFileName

End Sub

This is working file when using on Non-Web Forms, as we can write Embedded Procedure on any button, but there is no option available to write Embedded in buttons on web forms.

How could I export the data into Excel from Web Forms or Web Reports?

Thanks,