Convert Report into Excel Spread sheet

[cliffsimms]

I am not sure if this could be done or how to do it.
But I have been asked to convert a Report into a Excel spread sheet.

Can it be done and how would it be??

 

[Fornatian]

If the report is based on a query, output the query using the below command specifying the arguments as you go.

Docmd.OutputTo

Ian

 

[thocutt]

Another possibility is to open your report and file/send as Excel File and then send it to yourself and then just spruce up the excel file when you receive it. Just an alternative.