Access converts "!" to "$"

[ragtopcaddy via OfficeKB.com]

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.aspx/excel-programming/200806/1

 

[Rick Rothstein \(MVP - VB\)]

I've not used TransferSpreadsheet myself, but those quote marks around the
Range argument look suspicious to me. Try it with that last part like
this...

Range:=LeaseEvents!A3

and see if that works.

Rick