1. Use the Debug window and check that Forms!Ins!CQ
actually returns "Credit".
2. Try *without* the space after "Actual" (assuming you
have a directory "Actual" on C: drive.
HTH
Van T. Dinh
MVP (Access)
-----Original Message-----
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 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"
.
|