All,Can anyone explain how I would create an Excel drop down menu (a la File, Edit, View, etc) using a C++ XLL built with XLW technology.Thanks,F.

I'd be keen on seeing this too

Download the macro function help file from Microsoft (http://support.microsoft.com/kb/128185/EN-US/), then open the Macrofun.hlp, go to "Contents", then "Macro functions listed by category" and then "Customizing". Read up on function "ADD.MENU", "ADD.COMMAND", etc. The functions are old Macro Excel functions which translate 1:1 into an Excel4 call.

Chaenle,I'm not sure this is what I am looking for; I know how to build a menu in Excel and also how to create an XLA to do so. What I'm struggling with is building some code in C++ wrapping it up in an XLL and for this XLL to create a drop down menu when it is loaded in Excel.If I've misunderstood your response and it does explain how to do the above I'd be grateful if you could clarify.Thanks

We are in the process of exposing more of the Excel C API conveniently wrapped up. You will find in the example project a demonstration of how to add menu items.The latest dev versions can be download here:http://sourceforge.net/projects/xlw/fil ... lw%205DEV/

QuoteOriginally posted by: RedAlertAll,Can anyone explain how I would create an Excel drop down menu (a la File, Edit, View, etc) using a C++ XLL built with XLW technology.Thanks,F.All you need to do is use the appropriate macros. Here is an example using http://xll.codeplex.com/.

QuoteOriginally posted by: chaenleDownload the macro function help file from Microsoft (http://support.microsoft.com/kb/128185/EN-US/), then open the Macrofun.hlp, go to "Contents", then "Macro functions listed by category" and then "Customizing". Read up on function "ADD.MENU", "ADD.COMMAND", etc. The functions are old Macro Excel functions which translate 1:1 into an Excel4 call.I missed your reply on first reading. You are spot on. C# is the way of the future, but if you just want to deliver a portable and performant solution, xll's are great for that and the macro function help file is the Rosetta Stone. Here is how to create a dialog box in a few lines of code old school style: