TransferSpeadsheet help

[mike]

Hi. I'm writing a procedure that will create a temporary table, and then
export that table to Excel. I keep getting an error on the
TransferSpreadsheet line of code. Here's the line that's generating the error.

DoCmd.TransferSpreadsheet acExport, , [Temp Revenue Template], strPath &
strFile

The error message states:
Run-time error '2465'
Microsoft Access can't find the field '|' referred to in your expression.

The path & filename variables create a valid filename. The [Temp Revenue
Template] table has been created correctly, and all the field names are
valid. I can't figure out what's generating the error. Any thoughts?

 

[Ken Snell [MVP]]

Try this:

DoCmd.TransferSpreadsheet acExport, , "Temp Revenue Template", strPath &
strFile

The table name should be presented as a text string.

 

[mike]

Thanks Ken. That did it.

Try this:

DoCmd.TransferSpreadsheet acExport, , "Temp Revenue Template", strPath &
strFile

The table name should be presented as a text string.
--

Ken Snell
<MS ACCESS MVP>

Hi. I'm writing a procedure that will create a temporary table, and then
export that table to Excel. I keep getting an error on the
TransferSpreadsheet line of code. Here's the line that's generating the error.

DoCmd.TransferSpreadsheet acExport, , [Temp Revenue Template], strPath &
strFile

The error message states:
Run-time error '2465'
Microsoft Access can't find the field '|' referred to in your expression.

The path & filename variables create a valid filename. The [Temp Revenue
Template] table has been created correctly, and all the field names are
valid. I can't figure out what's generating the error. Any thoughts?