zHTML
Convert your VBA code to HTML text
NEWSFLASH!! - zHTML is now available on line! - Click here
zHTML is a utility I wrote because I'm sick of copying and pasting VBA code from the VBIDE into FrontPage and then having to colour it. This allows you to select a line, a procedure, a module or a project and creates an HTM file on the c:\ drive.
The code is invoked using a command button on the Tools menu:
Which shows the userform:
This is COM addin which means it works in all Office products from 2000 on.
zHTML is now available on line, convert VBA to HTML where-ever you are - Click here
The HTML in the files might not be as pure as some would like, but it works. I would point out that by it's very nature, this addin doesn't cope very well with code that has HTML tags in it.
I toyed with the idea of opening notepad.exe and displaying the HTML as text, so copy and pasting would be easier. If anyone feels strongly enough I'll add that in. The addin works by reading each line you selected into a variant array, and then checking each word against a list held in a text file stored in "c:\Program Files\zHTML\zHTML.txt". I originally had all these words in a module and read from there, but decided if I put them in a file, you can modify it to your hearts content. (Let's face it, there'll be an obscure word I missed). If you've lost your version of that file, get a new copy here.
