How do I control Excel 2007 Ribbon?

mathlover has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: How do I control Excel 2007 Ribbon? by Anonymous Monk on May 05, 2011 at 00:42 UTC
Is it possible to do that from Perl? Yup	[reply]
Re^2: How do I control Excel 2007 Ribbon? by mathlover (Initiate) on May 05, 2011 at 01:27 UTC
Wonderful! Can you please show me a code snippet that explains how I can tie the callbacks functions in Perl code to the ribbon definition? For example, I need to define a callback function in Perl to set the name of a label for a group that is defined by the following tag: `<group id=”myGroup” getLabel=”myGetLabel”>` I am assuming that I have to use Win32::OLE->WithEvents but I am not sure how to do it.	[reply] [d/l]
Re^3: How do I control Excel 2007 Ribbon? by Anonymous Monk on May 05, 2011 at 01:36 UTC
Can you please show me a code snippet that explains ... Nope. I offer you Office Automation with Perl, How do I convert a VBA macro to Perl?,Using Win32::OLE and Excel - Tips and Tricks, OLE withevents site:perlmonks.org ; the rest is on MSDN :)	[reply]