Excel 2007 menus - XML Notepad 2007

[michael.beckinsale]

Hi all,

This post is aimed at those who have 'experimented' with the new
XL2007 Menu and are familiar with the 'Custom UI Editor'. I have very
little knowledge of XML

For those interested (and did not know) MS XML Notepad is available
for download, free of charge, at the following link.

http://www.microsoft.com/downloads/...49-787D-4118-BA5F-4F30FE913628&displaylang=en

I found it really useful for creating XML to customise the ribbon and
add menu controls. There is a tree view showing the nodes where you
add / delete tabs, groups, buttons, comments etc. On the right hand
side you simply add your description in plain english. A seperate tab
(XSL Output) converts the entries into XML inserting the relevant
characters (<---text-->) and does all the indentation.

If you copy the 'customUI.xsd' schema file from the 'Custom UI Editor'
you get the added benefit of Intellisense to ensure that you only
apply valid attributes etc. Validation and error checking is carried
out as you type.

To add the schema:

1) Open XML Notepad 2007
2) View
3) Schemas
4) File
5) Add schemas
6) Locate the file 'customUI.xsd' and click on Open

As always there appears to be a downside in that you cannot attach the
XML to an XL file directly from XML Notepad. (I think you should be
able to do it via the XSLT Location / Transform facility but l have
not worked it out yet. Any info gratefully received.) You need to save
the XML file and apply to the XL file using the 'Custom UI Editor'

Hope this is useful. All feedback gratefully appreciated.

Regards

Michael beckinsale

 

[Ron de Bruin]

Hi Michael

Thanks for posting this
I will add a link to the page on my ribbon page

 

[Ron de Bruin]

Hi Michael

It is nice but Not what I am looking for.
I have other ideas to build the xml menu for the normal people <g>

 

[michael.beckinsale]

Ron,

Looking forward to seeing your version (soon?).

As you say its nice. I like the 'Intellisense' feature in particular.
It helps numbskulls like me who cant remember what attributes go with
what buttons etc.

I also think it helps to get an understanding of XML construct /
terminology. ie Element, Attribute, Parent, Child etc. However l still
have not got a clue what to do with CDATA Section & Processing
instruction (although l suspect that you can some how use this to
generate callbacks or invoke so other code. Maybe VBA? That could be
extremely useful.)

Pls keep me posted.

Regards

Michael Beckinsale.

 

[Ron de Bruin]

Hi Michael

I do my best to have my idea working next week.
Maybe it is not working but I will invest some time in it.

Have a nice weekend

 

[Ron de Bruin]

Here it is

http://www.rondebruin.nl/ribbon.htm

Direct link
http://www.rondebruin.nl/files/XMLCreator-1.3.zip