export

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"
 
V

Van T. Dinh

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

export 1
Exporting a table to another database 4
export to excel and name the file 1
Export Query Name 1
Export and email table 4
Date Parameter on export 3
VBA - retrieve data on last create named range from previous inserted named range 0
Using Forms to Export Data from an Access Table to an Excel Spreadsheet 1

Top