I am trying to use TransferSpreadsheet to export data to a template workbook.
Here is my code:

DoCmd.TransferSpreadsheet _
TransferType:=acExport, _
SpreadSheetType:=acSpreadsheetTypeExcel9, _
TableName:="qryLeaseEventStores", _
FileName:=strRptPath, _
HasFieldNames:=True, _
Range:="LeaseEvents!A3"

When I run it, I get the following error msg:

Run-time error '3126':

''Lease Events'$A3' is not a valid name.

Any ideas? I've done similar transfers dozens of times and never had this
problem before.

--
Bill Reed

"If you can't laugh at yourself, laugh at somebody else"

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200806/1