Help Wanted
For Students
Business Books

(under construction)

I have here various macros and programs written using visual basic (Word's macro language and an independent programming language). Naturally, they are offered without any warranties, as is, at your own risk, and so forth. Download the template with the macros and put it in your template directory. Generally speaking, I have found this language that Microsoft produces commercially (Visual Basic), expensive as it may be, much cheaper than the free Java, which is a royal pain to program and to learn. By contrast, Visual Basic comes with extraordinarily helpful 'help files' (but you do have to chose to install them when installing Office; if you did not, get the CD and go into the options and have them installed) and intuitive instruction. What is all the more astounding is that they are in actual English rather than computerese.

Template containing the following Macros: The document that opens with this template is my attempt to approximate law review formatting. You will notice that in the acknowledgement footnote there is an acknowledgement to me for the template and macros. That is my price for the templates, that you acknowledge their use and provenance in your product. At the top left of the first page you will see two macro-buttons, one that counts the document's words (including footnotes, which the wordcount field does not count), and one that fixes the spacing of the table of contents/outline is it gets messed up. The headers referring to the title and author of the document take their values from the document properties, click on file/properties and set them as you like.

FixWest: Macro that converts WestLaw downloads: Downloading cases or articles from WestLaw is good but the formatting leaves a lot to be desired. The formatting is ugly and the footnotes are in the main text. This macro will fix the formatting and make the footnotes into real footnotes. It will retain their original numbering or other reference sign (*, or **, for example). To use, download a document from WestLaw in Word format, then paste the text into a new document.  Special formatting in some of West's cases prevents conversion; compare the product with the original document. As Westlaw changed its formatting, the macro will not work on some recent documents. I have created a companion macro that "pre-fixes" downloads from LEXIS so that the FixWest macro can be run on them, hopefully, I will upload the new template eventually.

Palm<==>Word: Macro that converts Word documents into raw text and back using my own markup language (I've tried to have it be somewhat similar to HTML). Converts footnotes, italics, hidden text, strikethrough, headings, field-codes (nested too), maintains proper cross-references (i.e., see note 54 would get updated to 62 if you insert some more notes that change note 54 to 62), allows non-breaking spaces. The purpose is to be able to work on the handheld computers which do not support these features (PocketWord does not even support footnotes). Needless to say, I find writing using Palm's graffiti alphabet very effective, particularly since I can write anywhere I can take the Palm. In PalmOS computers, write using a text editor, such as Paul Nevai's pedit. Drop into Word from the Palm desctop or (for documents over 4K long) export the document to Palm DOC format, which after you synchronize, appears in your Palm/username/backup directory as a filename.PDB file. Convert to a text file using, for example, the free utility DocInOut, copy into a word document, and run the macro. Follow the opposite sequence to get it into your Palm (remember to install the PDB file from the Palm desktop). Markup Language guide

FileOpen: Macro that replaces the File/Open dialog so you can use various filename extensions in Word. 

Insert DocVariable/Manage Doc Variables: Macros that insert and let you manage document variables. Useful for building examples with chain calculations. If you base them on document variables, you can change them at one spot and all the references and calculations (using fields) will update.

Blue Background Toggle: Few use this very useful feature of word, because it is hard to switch on and off.

Analog Clock program: This is not a macro but an independent Visual Basic program. It displays an analog clock at the top left corner of the screen. With programmable recurring alarms. Right-click for menu. Source Code (pending). Installation Files

Option Valuation Spreadsheet: An excel spreadsheet that calculates the Black-Scholes call value as well as gives a rough estimate of the implied volatility and time-decay (the theta in options-speak). Sheet.

First Grade Math Test Spreadsheet: This is a spreadsheet with 30 addition and subtraction problems that I wrote for my son when he was in first grade. A new test is built (using the random number generator) every time the sheet is opened. Buttons on the sheet allow one to create new sets of problems, or to run a timed test (duration: 3 minutes). In the regular mode, errors are pointed out by conditional formatting (the cell turns red if the addition was wrong). In the time-test mode the cells remain normal, and the conditional formatting is turned on at the end of the test. I have tried to put remarks in the code so it is readable. Sheet.

Finish Line Puzzle: This is a little Visual Basic program (version 5.0) of an old brain teaser. The board is a row of 10 holes. The leftmost 4 holes have 4 red pegs and the rightmost 4 holes have 4 blue ones. Move them alternatively one or jump one blue to reverse their position. You need a vbrun module, which you probably have in your /Windows/System folder. File.

Back to my Other information page

Back to my Home page