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.......