Unable to Export Excel report with Command button

[b.saimsc]

Hi all,

I have created report and It's generated manually (Header--External Data--Excel)Perfect. But if I use command button click it's getting error message of "The action or method requires a Table Name argument". I have used the below mentioned formula.

Private Sub Command18_Click()


Dim theFilePath As String


theFilePath = theFilePath & "_" & Format(Date, "yyyy-mm-dd") & ".xlsx"


DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel10, Report1, theFilePath, True


End Sub

Can you please help me....

Thanks in Advance.......

[June7]

You declare variable theFilePath but do not include drive\folder path in the string.

Also, Report1 needs to be within quote marks, assuming that is the actual name of table or query.

Think must use OutputTo method in VBA to export report http://msdn.microsoft.com/en-us/library/ff192065.aspx

[b.saimsc]

Thank you Super Moderator..