Menus

[dvannoy]

I have created a custom menu in one of my projects. I have one little problem. I need the option "Analyze it with Excel" When I created my menus I did it through Macros and the AddMenu option. The only option I could find was "Output to Excel"..But that creates a .xls file.

Does anyone know of a way to get the Analyze it with excel option on the menu..I would like to put it under "file"

Thanks
DVannoy
A+,Network+,CNA
dvannoy@onyxes.com

 

[Guest_imported]

Hi,

In VBA, you use the DoCMd command to run the DoMenuItem command. This allows you to run any menu item.
Example
DoCmd.DoMenuItem