An excel based pay-slip generating app
Yesterday (7-Oct-2003), I finished and previewed a mini payroll solution built on Excel/VBA/Word combination.
Excel is used as the data store, I used VBA to extract the data and generate a Word Doc containing pay slips.
It took maybe about 1-2 hours to code and its fairly cool. Mainly because it solves a big problem simply. (although macros drive the application, it still contains at least one Class, and a few well defined Static Classes aka Bas Modules and an Enum).
Today, I am going to add a really neat back calculating feature that calculates the salary components based on a given Net amount.
Excel-VBA-Word combination is true RAD, in fact its more like Instant-Application-Development.
posted earlier in my previous blog (http://22blog.com/richardh/) on 8-Oct-2003