These are projects posted by the students of Dr. Gove Allen at Brigham Young University. These students have taken one semester-long course on VBA and generally have had no prior programming experience

Tuesday, April 13, 2010

Ward Directory Creator

Executive Summary

For the last two semesters, I have been in charge of the ward directory for my BYU ward. My responsibilities include taking everyone’s picture and then creating a picture directory with names and phone numbers. The names are in ABC order by first name. It may take three to four weeks to obtain all the photos, but the Bishop prefers to have an up-to-date copy to help in making church assignments. Since I do not have a program that will auto generate anything for me, I have used PowerPoint to recreate the directory each week by rearranging the pictures as new ones come in. This process can take a few hours each time, especially as the number of photos increases to 200 or more.

I have created a program that will automatically login to the website and scrape the site for ward member data. It will fill in an Excel spreadsheet with each ward member’s first name, last name, phone number, and address. Additionally, the program will search the “Photos” folder for ward member pictures based on the filename. If pictures are found, they will be inserted in the appropriate spreadsheet rows. Note: the program has been designed to search for .jpg picture files.

Ward Directory Write Up

Excel File

"Photos" Folder Example

No comments:

Post a Comment

Blog Archive