has developed a system that facilitates documentation in connection with development of systems in Excel. By making use of the system a programmer can easily let the internal documentation be available for those that are to use the system.
The automated handling of the documentation is implemented in workbooks for Excel that use macros. It works approximately in the same way as when documenting in Java (a programming language).
Documentation can be introduced in all development components that are written in VBA.
Following are some examples of tags that can be used:
- @Author: - Creates a two column table with one row for each author and tag.
- @Version: - Creates a three column table with one row for each version and tag.
- @Param: - Creates a two column table with one row for each parameter and tag.
- @Caller: - Creates a two column table with one row for each caller and tag.
- @Calling: - Creates a two column table with one row for each called routine and tag.
The system automatically detects the name of routines and possible attributes and return value.
The following picture shows the interface when deciding from which workbook that documentation should be extracted. You may also decide to only extract documentation for selected components, if you so wish to.
Below follows two extracts of the internal documentation from a workbook and after that a link to the html file that is created.
The link: Extracted Documentation in HTML format
Call or mail Magnus Dahlberg for further information about how
can help Your Company.
Satisfied customers is the alpha and omega for