Convert your Code to Color-Coded HTML (Access 97)

Author: Gary Walter
Category: Database
Type: Applications
Difficulty: Intermediate

Version Compatibility: Visual Basic 6

More information: Save your module code in a text file (or code less than 32767 chars can be copied to clipboard). Then you can use this database to import the code into the db. Set any lines you want to be red-flagged. Set HTML title, Home page address, webmaster mailto address, and HTML colors for comments, blue-words, and flagged lines.

Save the code to a complete HTML page with a list of all procs at top of page with links to them in the page. At end of each proc is a "back to top" link.

At end of save, given the option to view page in your browser where you can print your code to a color printer or, for old-eyes like mine, increase text size.

Other save options are to save just the HTML version of your code to a text file or to the clipboard which you can then just paste into your web page.

The latest version, added 10/07/01, includes a number of enhancements, including:

Added routine to open another database and get code modules directly from that database (including class modules). You can now select another db, get back a list of procedures in that db, and choose which procedure codes you want to convert to HTML.
Added form to change HTML Color Codes.
Corrected catching some reserved words that were being missed in previous version.
This code has been viewed 56224 times.

Instructions: Click the link below to download the code. Select 'Save' from the IE popup dialog. Once downloaded, open the .zip file from your local drive using WinZip or a comparable program to view the contents.

source/HTMLCode.zip