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

Journal Entry Wizzard

I chose to automate a mundane daily task at by job for my VBA project. Every day I receive a list of individuals whose refunds must be reversed. It is my job to use this list to create the journal entry that will actually reverse the refunds. To do this, I have to copy and paste the information over one piece at a time and change a variety of items so they are in the correct format for the journal entry. The program I wrote allows the user to create a properly edited and formatted journal entry with the click of a button. This program will save me at least 10 minutes every day (and a lot of grief) at my job. I also created a "Yahtzee" game that I can play with all of my saved time at work.

Project Write-up:
http://files.gove.net/shares/files/11w/jjordan3/JasonJordan_ProjectWrite-up.pdf

Journal Entry Wizzard with extra "Yahtzee" Game:
http://files.gove.net/shares/files/11w/jjordan3/Automated_ACH_Return_JE.xlsm

Example of the raw data file I get every day:
http://files.gove.net/shares/files/11w/jjordan3/RawDataFile_Example.ps.csv

No comments:

Post a Comment

Blog Archive