Site Map Worksheet

This was the most difficult code to write. You have to recursively go through every folder and organize the results in nested unordered lists.

It was first written in APL over three weeks. Later it was rewritten on VBA, with optional additional post processing and speedups. The post processing:

The site map is built in the order it finds the links. Your can add comments to your HTML to disregard code, knowing the links will be found later in a more appropriate position.

A report is returned with statistics and any error messages or warnings.

The module with the VBA Code.

site map sheet