export

[Guest]

Hello I am using this VBA comand to attempt to copy an
access table to excel. It contiuously gives me an error
that it cannot find the Object. The object I am trying
to export is an access table, which is called "Credit
Table" and I am using the Form to allow the user to
choose
which table to export (the reason for the Forms!Ins!CQ
section)

do I need to add something to specify that it is a table
I
am exporting.

DoCmd.TransferSpreadsheet acExport, , _
Forms!Ins!CQ & " Table", "C:\Actual \Trend.xls"

 

[Allen Browne]

Because your table name contains a space, you may need to add square
brackets:

Dim strTableName As String

strTableName = "[" & Forms!Ins!CQ & " Table]"
DoCmd.TransferSpreadsheet acExport, , _
strTableName, "C:\Actual \Trend.xls"

The folder name ending in a space also looks wrong.