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

Wednesday, April 13, 2011

US Bank Financial Form

As a married BYU student with three kids, I quickly learned that managing my finances was going to be very important. After being at BYU for several years, I realized there were also many other students that were in a similar situation. This program has a basic layout that will allow the user to organize their finances, but the VBA code that I added to this sheet is where some of the more powerful functionality comes in. First, many people keep track of upcoming expenses to ensure they have enough money available for the expenses. This program will gather the data from the user’s calendar and import the data into a worksheet for easy access. Next, the program will ask the user for their login and password for US Banks’ website and gather all of the necessary bank information. Finally, a button has been added to generate basic reports that can be printed for general record keeping.

http://files.gove.net/shares/files/11w/tallguy2/Budget_Workbook.xlsm
http://files.gove.net/shares/files/11w/tallguy2/Final_Project_Writeup.pdf

The calendar program I used for this project can be found at:
http://download.cnet.com/Calendar-Magic/3000-2124_4-10496716.html?tag=mncol;1

No comments:

Post a Comment

Blog Archive