View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default CommandBars in 2007?

A cross-version approach consists of two files. First is a Classic Excel
(i.e., 2000 through 2003) add-in, which does all the work, and detects the
version of Excel. If the version of Excel is Classic, it builds the menus
and commandbars as before. If the version is Excel 12, it opens the second
file. The second file is an Excel 2007 add-in (not installed as an add-in by
the way) with the XML code for the RibbonX modifications as well as the code
that catches ribbon clicks and runs the appropriate command in the Classic
add-in.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Maury Markowitz" wrote in message
...
On Jun 20, 8:05 am, "Jim Rech" wrote:
The Quick Access Toolbar (QAT) was provided by MS for end users to put
their
own custom/favorite items in easy reach. MS did not intend for developers
to use it themselves and made it almost impossible to do so. So the way to
proceed as a developer is to learn RibbonX.


But am I right to assume that RibbonX does not work under older
versions? Is there any cross-version system that works well?

Maury