Export to Excel template

Can anyone tell me if / how I can export a report into a pre formatted excel spreadsheet? I want to be able to manipulate the report using VBA and macros....anybody help?