If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
export
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" |
#2
|
|||
|
|||
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" . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Export data from OLE object in PowerPoint | Brett Ellingson | Powerpoint | 8 | August 25th, 2004 12:28 AM |
export 1 query 5 times to 1 excel file | Mike_Walrus | Running & Setting Up Queries | 7 | June 20th, 2004 01:09 AM |
export 1 query multiple times to 1 excel file | WALRUSIM | Running & Setting Up Queries | 1 | June 19th, 2004 04:13 AM |
export 1 query 5 times to 1 excel file | Mike_Walrus | Running & Setting Up Queries | 0 | June 19th, 2004 02:00 AM |
Can't export calculated fields to Excel | Sharon Caspers | Setting Up & Running Reports | 0 | May 26th, 2004 08:31 PM |