RunCommand - ExportExcel

H

h2fcell

In Access 2007, I’m using a macro to AddMenu. The “Menu Macro Name†is
mcrShortcutMenuCommands.
In it I use RunCommand for Print, Zoom100%, PublishFixedFormat which is used
to Save as PDF, and ExportRTF which kicks off a Send via email dialog.

I’d like to add RunCommand - ExportExcel so that it could kick off the
“Export – Excel Spreadsheet†dialog window, but when I add the RunCommand
ExportExcel to the Macro it appears ghosted in the shortcut menu.

Does anyone know why that’s happening or how I can kick off the Export –
Excel Spreadsheet dialog window from my shortcut menu?

Thank in advance for your help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Expression - Type Mismatch 0
Outlook 2003 problem 1
Switching Back to Query Form 3
Adding Sequential Numbers to a Query 1
Excel 2007-macro programming logic for data validation 2
Excel 2007-programming macros that apply to data validation 1
File in Use dialog when I Open an extra excel via the (start menu) 2
Run-time error '1004' on server extraction 0

Top