Send info to Excel by Macro

[S]

I have some experience with Macros but I want to have a
command button in a form to send information to an excel
spreadsheet. Can that be done?

Also, to go a little deeper, can you send the information
to a specific location within excel or can it only be a
new worksheet?

Please help? and try to use easy explanations. Thanks,

 

[Steve Schapel]

S,

You can make a macro using the TrnasferSpreadsheet action for this.
Enter TransferSpreadsheet in the Action column of the macro design
window and then press F1 to get some more information about this. You
can export data from Access to an existing Excel file, but as far as I
know you can't specify a specific location within the worksheet. To do
this, I think you would need to use a vba procedure whereby you open the
spreadsheet via Office automation, and position the data cell by cell.

 

[Michelle]

You can send information to excel with a macro and overwrite the information contained in the excel cells. You need to use name define in the excel workbook to define the cell range on the work book to send the information to and then when you export, in the macro you need to make sure to export to that named range. I am sure there are other ways to do this also.