Outputting to Excel

[sheetal]

I have created some reports in Access, and want to create a macro that
will open and run and then export to excel. How do I do this?

I have started the macro by writing OpenReport, and naming the report.
I get stuck when it comes to exporting to Excel. Do I need to go into
the VB? If so, what would be the code?

Please help, Thanks

Sheetal

 

[Jim/Chris]

Instead of OpenReport use OutputTo
This will export the report named to Excel
Jim

 

[jpcok]

In my macro I Use the action open query/output to(set the
export format to excel)