RunCommand - ExportExcel

  • Thread starter Thread starter h2fcell
  • Start date Start date
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.
 
Back
Top