Tip: Album Generator

 Kishore C.S. (May 2001)

 The following is a simple Excel Macro I have used to generate Photo Album for my home page. I had around 25 photos and I wanted to provide an album where I can include some caption and provie links for navigation. I searched web to see if any such tools are available. I could not find many. So I spent sometime in generating this tool. I am sharing this so that you can use it if you want to. You can make changes to suit your requirements.

Click here to view the photo album generated using this Macro

Features of this macro

1. Generate HTML pages based on configuration mentioned in Config Sheet

2. Include Previous Photo, Next Photo links in each HTML page

3. Skip giving Previous Photo in First Page and Next Photo in Last Page

4. Add a Index Page. (If required you can choose extend this Macro to generate a Index Page also)

How to Use

1. Download zip file and extract file to a folder

2. Edit Excel Sheet to include your photo captions and image file names in "Photo" Worksheet

3. Edit config to suit your requirements  in "Config" Worksheet.

4. Use Run Macro Option to Run Macro attached to Excel Sheet

You will get the HTML files as you need in folder mentioned in Config Worksheet. Deploy the HTML files generator in your local website.

Hope you will find this simple tool useful.