Excel menu with XML (Excel 2003/ XML (pro UK))

Topic

New Reply

Hi

Toying with an idea of an easy to use ‘XL menu builder tool’ that requires no programming skills.
What I want is to make a generic XLA, that reads any given XML file. And based on that constructs the menu.

All user needs to do then, is to fill in tags in an XML file. Using hierarchies.

Thought of an XML looking something like this:

TRUE
TRUE

Reply | Quote

Replies

This might help: post 343,644

Because it’s for Outlook, the CommandBars collection belongs to a different object, but otherwise, it should be analogous.

Reply | Quote

What is wrong with using a table of cells in Excel itself as opposed to XML (which is harder to edit IMO)?

There are ample examples to find on table driven commandbar creation on the web.

Reply | Quote

Hi Jan,

Thanks for the tip.

Do you have a good keyword to get off to a good start…(maybe sth. like ‘table driven commandbar’ ?)

Reply | Quote

Search google for the book called “Professional Excel Development” and purchase a copy. Worth it’s weight in platinum and contains exactly this.

Reply | Quote

Hi Jan,

Thanks for the tip. Book looks exciting – have ordered it / ;o)

btw: Reason for not stating the “using-Excel-itself” angle was that I somehow thought it to be to simple (don’t know why really)
Looking in the always clear rear view mirror it seems so simple and obvious to try to achieve a very simple menu build that way.

So – thanks for straigthening out my crooked thoughts

Reply | Quote

Simpler is pretty much always better (provided you get the same functionality).

Reply | Quote