Page 1 of 1
Excel drop menu using XLL - XLW
Posted: April 9th, 2006, 5:14 pm
by RedAlert
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.
Excel drop menu using XLL - XLW
Posted: April 11th, 2006, 7:20 am
by mutley
I'd be keen on seeing this too
Excel drop menu using XLL - XLW
Posted: April 11th, 2006, 12:52 pm
by chaenle
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.
Excel drop menu using XLL - XLW
Posted: April 16th, 2006, 8:33 am
by RedAlert
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
Excel drop menu using XLL - XLW
Posted: May 12th, 2011, 3:40 pm
by AlexesDad
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/
Excel drop menu using XLL - XLW
Posted: May 16th, 2011, 9:21 pm
by kimosabe
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/.
Excel drop menu using XLL - XLW
Posted: May 17th, 2011, 3:14 am
by kimosabe
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: