There are many utilities here:
- Collecting all the CSS code into one file for easy finding of past code examples. There is a button here to open the file, but having it saved to my Desktop, I click it there. There is a list of folders with CSS code that isn't mine, and I don't want included.
- There is a button that collects all the CSS file usage, and groups the folders that use that CSS file.
- A utility looks for images in a folder that are not used.
- Ampersands no longer need to be escaped. But other than in URLs, it is good practice to still escape them. This looks for the unescaped ones.
- There are three statistics listings that have buttons in the Dashboard. They are repeated here.
- Statistics for each Slide Show:
- Page Count
- Thumbnail Size
- Thumbnails Total KB
- Image Size
- Average Image KB
- Folder Path
- Slide Show Option Usage. Three options are turned on by the presence of files in the show's folder. This lists which folders are using them:
- Captions.txt - has a row for each image.
- Heading.txt - puts a heading on each image's page.
- Subheadings.txt - These are blocks of code that are inserted before a specified thumbnail.
- Find Unused Jamaica Images. Goes through each of the sections.
- Folder Htm Stats. This lists all the various folder data files that are used to create the htms on the AddNav sheet. You can then edit the files from the sheet with Ctrl-R and the cursor on the row.
- For the Picture Albums we have three utilities:
- Listing ai_ files, lists the album information files. Has number of rows (some are optional), the date in the file, and whether the file is a group file.
- Info on Albums. The columns:
- Web-size average
- Web-size maximum
- Original image average size
- Original image maximum size
- Picture Count
- Maximum length of picture data files (pd_ prefix)
- Album name
- Find Unused Data. Lists all the folders, and their file contents, that were found on the hard drive and are not included in any picture albums.
- Various buttons let you analyze and correct the results.
The module with the VBA Code.