Microsoft Excel along with VBA Programming is a very powerful tool to automate a number of tasks we do in our daily routines. A number of data analysis, data maintenance and manipulations, report generation jobs in excel can be made easy and You can build some really cool stuffs using Excel features and VBA Programming to create macros. Learning Excel and VBA programming is probably the next easiest thing to do as You find a crowd of online resources on the web. Personally I learnt most of the basics from the following two sites:
(Click here to Download)
I am a big fan of Excel and VBA Programming and have developed a number of small utilities most of them related to my project work. You may these sheets directly as they are or customize them according to your needs, but but the code embedded in these sheets can definitely be a source of reference to develop Your own utilities as per Your need. Click on the download link to download the Excel workbook.
|1. Split Costs (Click to download Workbook)|
Its a ready to use utility to split the cost incurred during a trip or event where the total amount is shared by more than one person. Its a sort of account maintenance tool where the total expenditure is shared by a group of people either for a event or for a particular period of time. Typical uses are Trip or picnic expense management, Mess Expense Management, Party expense management etc..
|2. Weekly Status Reports for IT Projects (Click to Download Workbook)|
The Weekly Status Reporting Tool is a standard Status Update Report which resources fill at the end of the week to summarize the tasks assigned and worked upon in the week. The resources fill up the Status report sheet and the Billed Hours sheet and the manager is responsible for the control sheet maintenance and use. The Workbook should ideally be placed in a common drive and resources should fill it up one at a time. Various useful analysis reports can be generated by the tool which aid in team performance analysis and making correct forcasting and assignment decision.
|3. Sending Emails from VBA Applications(Click to download Documentation)|
Many a times Your VBA application may need to send dynamically generated/static emails to various email addresses. These email address and data can be from the Workbook itself. Here are two approaches of sending out emails from Your VBA Applications.