Export to Excel button is always disabled (Access 2007)

[dougie]

I notice that, no matter the context, the shortcut menu button to export to Excel is always disabled. The Export drop down button is enabled, but it only shows PDF and XPS as target formats. However there is no problem in exporting to Excel from tables, queries or even reports using the ribbon tools. I want users to be able to export selected reports to Excel but I don't want to give them full access to the ribbon. Is there a way of doing this? I'm using Access 2007 SP3.

Update: a further curiousity. If the database is in accdb format, I can use print preview, right-click on the preview, then select Export...>Excel and that works. But the Export option isn''t available after conversion to accde format. Rats.

[June7]

Customize the ribbon and Quick Access Toolbar. Review this http://forums.aspfree.com/microsoft-...at-303789.html

Or have a button on a form.

I have never set up accde so don't know how customization will behave.

[dougie]

Thanks - I'll go the XML way. The button actually needs to be on a report and it's too much hassle to go through them all adding it.