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:
- Combining folders into contiguous blocks
- Moving sub-folder calls -- e.g. to PDFs -- to end of folder
- Making sure index file is first in folder
- Bring sub-subfolders to parent
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.