I wish to create a button on the report, which users can click and that will export the report data to an excel file. I am using access 2007 & excel 2007.

What code would I need to insert behind the button (my database is split and each user has their own front end).

Cheers

Look at TransferSpreadsheet in VBA help. It would be the simplest. You'd want to export the underlying query rather than the report itself.