If you haven’t seen it yet, you should click here
I’ve always wanted to build a fully blown expression parser but didn’t really know where to start.
There is some great information in that post – the extra reading was helpful too.
So, I set about writing my own in VBA using the points and methods learned from that post. There sure are a lot of things to think about. Here is some of the trickery I encountered…
A formula parser-tokeniser is not very useful unless you do something with it – so I’m starting with something simple:
An add-in for formatting and editing a formula. I think they call it a ‘beautifier’.
Do a search on this website for “ugly formula” and you’ll see where this tool might be handy.
I intend to build more around the add-in as time permits. Perhaps an advanced search/replace tool? FindLinks? MultiWkb/MultiSheet Precedents grapher? Who knows.
I tried my best to accept International Regional Settings – no guarantees there.
F9 will evaluate a portion of the formula too.
It’s still beta as version 0.9.
Download AudXL.zip from my website: http://www.vangelder.co.nz/excel