I have a button on a form that allows users to preview a report.

I added "Anaylze with Excel Button" to the menu bar so users can open it with Excel after they view it in print preview.

How do I write the code for the button on the form to Open directly to Excel?

THANKS!

There's a button you can use that's already setup for you. Look under Commands >> Tools. Then you can drag the 'Analyze with Excel' button to your toolbar.