Download goes here. If you like it, rate it here.

Functionality
Tired of writing lexical analyzers by hand? 
They are error-prone, often inexcact, and difficult to maintain.
Here is small simple tool for simple cases. This tool cannot compete with LEX and YACC and similar professional tools. But it also has some advantages:

- It creates Visual Basic code
- It allows to add VB code as actions to production rules
- Results can be tested in the Excel environment
- Excel workbook serves as an archive for reuse

Background
Think about it: How many lexical analyzers have you written in your life? I wrote lots of them: read  .ini files, read/write registry entries, etc. Of course we all know about LEX and YACC but who did ever use it? It's overkill for these cases. And: they don't speak VB. This small tool does!

Prerequisites
Lex4VB is written in Excel 2000 VBA and maybe it only runs there. It makes use of some features of the VBA IDE object model and I'm not sure whether this runs in earlier Excels. Let me know! 

Installation
Just download the Excel workbook, read the help sheet and start generating your first analyzer.

Usage
See Excel workbook

How it works
See VBA source code 

Known issues
See Excel workbook

Revisions