LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Customized Menu Macro with Argument invoked twice

Outlook express does not expose an object model that can be driven by an
external application. Outlook (a totaly unrelated application with a
similar name) does expose an object model. I am not sure what the Menu
Editor.

John Walkenbach, on his site, has a sendkeys approach to manipulating
Outlook Express

--
Regards,
Tom Ogilvy

"Alan" wrote in message
...

Thanks for the suggestions. I downloaded Walkenbach's table driven menu
system. This works nicely, there are a few limitations:

- I finally identified how to include web links for some menu items. I
had to add another field to the table for the web link and update the
VBA code to set the menu item appropriate attributes.

- I want one menu item to popup the Outlook Express Send mail window
with the "To" and Subject Field initialized. I have not found a way to
start Outlook Express Send from VBA. There are many examples using
Sendmail and Outlook, but I haven't found one for Outlook Express Send.
The Menu Editor allows you to do this so it is possible.

- Cannot specify an argument for the macro. May need more columns for
the arguments.

I still receive "firing twice" when invoking a menu item macro with an
argument. I've tried removing the () as suggested, I receive an error
and cannot enter it. I've noticed my Menu Editor list of user defined
functions (ie macros) is a small subset of the udf's (ie user defined
functions) listed in the Toolbar Insert Function udf. I think the
problem may be related to the missing udf's in the Menu Editor. Any
suggestions on how to update the Menu Editor udf list to be consistent
with the Toolbar Insert Function udf list? They should be the same.

thanks.


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!





 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Customized Toolbar Macro Buttons MSThinksItKnowsBetter Setting up and Configuration of Excel 8 June 1st 08 09:28 AM
filter dropdown menu so 2nd drop menu is customized menugal Excel Worksheet Functions 1 September 4th 07 05:25 PM
Customized Macro Button Check [email protected] Excel Discussion (Misc queries) 1 August 11th 07 12:23 AM
Excel 2003 Customized Menu Bar Fernando Gomez Excel Discussion (Misc queries) 2 December 16th 04 10:28 PM
Argument with onAction in a menu. Zeth Larsson Excel Programming 8 December 25th 03 03:21 PM


All times are GMT +1. The time now is 09:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"