Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 menus - XML Notepad 2007
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/d...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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 menus - XML Notepad 2007
Hi Michael
Thanks for posting this I will add a link to the page on my ribbon page -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "michael.beckinsale" wrote in message oups.com... 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/d...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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 menus - XML Notepad 2007
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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ron de Bruin" wrote in message ... Hi Michael Thanks for posting this I will add a link to the page on my ribbon page -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "michael.beckinsale" wrote in message oups.com... 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/d...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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 menus - XML Notepad 2007
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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 menus - XML Notepad 2007
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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "michael.beckinsale" wrote in message ups.com... 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. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 menus - XML Notepad 2007
Here it is
http://www.rondebruin.nl/ribbon.htm Direct link http://www.rondebruin.nl/files/XMLCreator-1.3.zip -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ron de Bruin" wrote in message ... 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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "michael.beckinsale" wrote in message ups.com... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sub-menus of main menus for Excel 2007 | New Users to Excel | |||
Excel 2007 menus - how can I get rid of them? | New Users to Excel | |||
EXCEL 2007 Menus | Excel Discussion (Misc queries) | |||
Excel 2007 menus - is this right? | Excel Programming | |||
Menus in Excel 2007 | Excel Programming |