Copy data to excel

[benjacobs101]

Hi All

I'm hoping you can help!

I need to create a macro that opens a query, copies the data, opens an existing excel spreadsheet and pastes the data into the top row.

Unfortunately I don't have a clue about VBA - I was hoping I could record it, but now I know that you can't record in Access. :banghead:

I'm running Access 2007. The macro will be run from a form button. The form, query and excel spreadsheet have all been made and are working as I need them to. The macro is just the last piece of the puzzle!

Thanks

 

[Geotch]

You can use the ImportExportSpreadsheet or ImportExportData options in a Macro. I 've attached a picture.