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.
Initially each image was a page from some catalog, and each page needed no specific caption. Captions for each picture are now optional. Sub-heading sections in the thumbnail list are now implemented in two ways. Either blocks of code to insert, or strings are inserted into title containers.
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))
- 4- Put captions on Index page. Captions on Individual pages must exist first.
- 8- Use Captions file for image order.
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.