The Picture Albums were developed first. But then I needed slide shows to display catalogs and books. The macro creates the individual files, and inserts the thumbnail code into the index page. Arrows in the upper left control movement between pages.
Captions for each picture are optional. They are turned on by the presence of a Captions.txt file. One row for each picture. Row starts with the row number then a stile. Clicking the Captions button will intialize the file.
Sub-heading sections in the thumbnail list are implemented in two ways:
- Blocks of code to insert. Files named Subheadings.txt contain blocks of code to put in front of lines with the specfied id= number. A table of contents can be turned on with option 16 on the sheet.
- Strings are inserted into title containers
A Heading.txt file in the folder is used for each picture's heading, instead of the default folder name.
This is one of three sheets where a macro on Ctrl-R puts the row number you are on into the Row cell.
Options available on the sheet in columns:
- Publication Type Options:
- blank is nothing (just folder or heading text name)
- 1- Catalog
- 2- Folder
- 3- Pages
- 4- Photo
- 5- Slide
- Cover Flag:
- A blank is always labeled Cover
- TRUE makes page 1 labeled Cover
- Back Flag:
- Blank the last page has a number
- TRUE the last page is labeled Back
- Options are additive:
- 1- Put border around image on htms.
- 2- Use "-f" files. Default is numbers with prefixes (tp - thumbnail, wp - web-size, p - full fize (optional, used for webp))
- 4- Put captions on Index page. Captions on Individual pages must exist first.
- 8- Use Captions file for image order.
- 16- Add a table of contents on the index page.
- 32- Skip index numbers on index page.
There is a utility to resize and rename the images. More image processing is on the Images Utilities Sheet.
The module with the VBA Code.
