I am developing workbooks to be used in Excel 2007 and Excel 2003 that
use custom toolbars. I have a matrix and existing code in XL2003 that
uses the commandbar to build the toolbar. There is also code to create
the customUI.xml file for XL2007 in order to add a ribbon tab. The
files work as expected when opened in XL2003 and XL2007.

Until...

We have Microsoft Office Compatibility Pack installed that allows
XL2007 files to be opened in XL2003. When the file is opened in XL2003
and saved (the file type is not changed so it is still .xlsm) the
customUI.xml file is stripped out even though the conversion process
is used. Any ideas on how to retain the customUI.xml file?

On Sep 15, 2:09*pm, "david.w.terrell"
wrote:
I am developing workbooks to be used in Excel 2007 and Excel 2003 that
use custom toolbars. I have a matrix and existing code in XL2003 that
uses the commandbar to build the toolbar. There is also code to create
the customUI.xml file for XL2007 in order to add a ribbon tab. The
files work as expected when opened in XL2003 and XL2007.

Until...

We have Microsoft Office Compatibility Pack installed that allows
XL2007 files to be opened in XL2003. When the file is opened in XL2003
and saved (the file type is not changed so it is still .xlsm) the
customUI.xml file is stripped out even though the conversion process
is used. Any ideas on how to retain the customUI.xml file?

I figured out one part to it. When the xlsm file is saved in 2003 the
customUI.xml folder and the .rels reference is stripped out. If I
somehow add back the reference it will probably work again but I don't
want to do this everything we round trip from 2007-2003-2007.

Hi David

Yes that is a problem
I saw that when I create the last example on this page
http://www.rondebruin.nl/compatiblemenu.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"david.w.terrell" wrote in message
...
On Sep 15, 2:09 pm, "david.w.terrell"
wrote:
I am developing workbooks to be used in Excel 2007 and Excel 2003 that
use custom toolbars. I have a matrix and existing code in XL2003 that
uses the commandbar to build the toolbar. There is also code to create
the customUI.xml file for XL2007 in order to add a ribbon tab. The
files work as expected when opened in XL2003 and XL2007.

Until...

We have Microsoft Office Compatibility Pack installed that allows
XL2007 files to be opened in XL2003. When the file is opened in XL2003
and saved (the file type is not changed so it is still .xlsm) the
customUI.xml file is stripped out even though the conversion process
is used. Any ideas on how to retain the customUI.xml file?

I figured out one part to it. When the xlsm file is saved in 2003 the
customUI.xml folder and the .rels reference is stripped out. If I
somehow add back the reference it will probably work again but I don't
want to do this everything we round trip from 2007-2003-2007.