export

  • Thread starter Thread starter Guest
  • Start date Start date
G

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 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"
 
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)
 
Back
Top