I am trying to export some data in a spreadsheet:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "fnAuditTrailExport", _
... this in an Access2002 project. The help says that the source data can be in a query, but when I try (no matter what I try), I get error 7874, "Can't find the object "fnAuditTrailExport".
Anyone any ideas on how to export to a spreadsheet from a view, SP, or UDF?