The zipped bas files come in at 39KB, the zipped dot template comes in at
134KB. Unzipped it currently weighs 296KB.
I regularly compress the template & every now & again export all the modules
to a new template to clear out the rest of the junk that accrues as I'm
working.
The current code has a broken debugger routine (it did work a month ago, but
messing with the code means that I need to put this part back in order. This
isn't a problem).
The documentor exports the code as part of the larger routine & can export
it as a stand-alone utility, too.
It also creates a summary of the files & exports all the code to one or more
word documents that it then formats, TOCs (with cross-referenced hyperlinks)
& indexes (there's a keyword index & a key comment index which needs
hyperlinking to the line numbers when they're added).
The user can select more than one file to document & chose if they want one
documentor document created for the lot, or one documentor document for each
file being documented. It currently works with Word & Excel code. The Excel
part of the code needs rewriting as it currently doesn't release Excel, but
I think I know why & plan to tackle that by-the-by.
Examples of the output sans line numbers can be given.
The code currently tests for pass-protected files & projects without names
or descriptions. At some point I'll add a log file so that these files can
be recalled & "corrected", so that the code can then work on them. It isn't
any use to me to have a documentor which fails to record the project name &
description & you need a method of recording pass protected files to return
to them later (pass protected files mean that you can't get at the code to
export, so you need to remove the password first. Since this might not be
known, a return log is desirable).
The formatting is very ego-centric & set up for British A4 landscape &
portrait sizes, but the idea was to cram as much in as little space as
possible & have it legible, with hyperlinking of use when viewed in Word.
Some of the code has been taken from examples others have supplied &
adapted, sometimes heavily. I don't THINK I missed anyone, but I'm very
forgetful - just to say it isn't deliberate, & I'll be happy to give the
credit where it is due. I have, for example, borrowed from Chip Pearson, Rob
Bovey & Myrna Larson & would love to see what they make of it (not too
horrified, I hope).
I've been working on the code for several years, learning Word & Excel as
I've gone along, hence its higgledy piggledy look. I haven't yet got the
hang of class objects, which probably explains alot...
Anyone interested in helping me optimise the code are free to use &
distribute it themselves, provided they retain all the credits & let me know
what they think, so I'm not expecting them to do it completely selflessly!
The important thing for me is to get it as fully functional as possible.
I've no plans to do anything commercial with it, but it would put me in a
good position at work & home to develop my other projects.
The zipped file or files are available to any genuine offers of help from
anyone willing to give it.
Best wishes,
Terry.
