VBA (Visual BASIC for Applications) Coding

VBA can be a very useful development language to make desktop productivity applications like Microsoft Word, Excel, PowerPoint, Outlook and Visio even more user friendly and productive while at the same time making the data being used in these applications more centralized for better accuracy and broader sharing. 

While the Fantasy Football League (FFL) market is estimated to be a a $1 billion industry, the example below is for personal use and therefore can be freely distributed.  The application works in conjunction with services from MyFantasyLeague.com, and allows our league to take advantage of all their features including their head-to-head competition model and our additional end of season total points competition.  Even though data like fees, team names, and winnings payout percentages is stored in a separate and hidden spreadsheet, in our Excel woorkbook, it could as easily be retrieved from a true database server like SQL Server, MySQL or Oracle.

The Excel file and Users Manual are available for download below allows for:

• Creation of a New Season.
• Weekly Updates
• Final Standings at the End of the Regular Season
• Playoffs Standings
• Generation of HTML Files for Web Viewing (Any Given Sunday Winnings/(Losses) Season to Date)
• FTP of HTML Pages to Any Given Sunday Winnings/(Losses) Season to Date Website

Since this is an Office VBA application, it will only execute in a Windows-based environment.  Currently Microsoft's Office for Mac does not support VBA.

When downloading the Excel file, please make sure to place it in a unique folder, since it generates HTML pages and a new folder.  Furthermore, because of Excel's security model, you will see a message that reads 'Security Warning Macros have been disabled.' with an Options button next to the message.  Select the Options button and select 'Enable this content' followed by the 'OK' button.