|
Subject:
|
Transfer Spreadsheet
|
|
Posted By:
|
JamesHardiman
|
Post Date:
|
11/26/2003 10:17:20 AM
|
Hi,
I am trying to export some data in a spreadsheet:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "fnAuditTrailExport", _
SheetNameClubDate("AuditTrail")
... 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?
Ta,
James Hardiman
|
|
