Here is a sample spreadsheet that consumes RSS feeds from various pro football sources and combines them into one application, albeit in Excel.
- Feeds from all 32 NFL teams
- Team logo
- NFL.com news summary for each team, with option to visit website for full story
- Yahoo.com Sports news for each team, with option to visit website for full story
- Team website links
- Twitter feed for each team (except Indianapolis Colts)
- ESPN.com news from around the league (all teams)
The Colts do not have a Twitter feed — their owner does, though. Contact them and ask them to set up an official Twitter account for team news, and I'll add it to this application!
If you are on Twitter, don't forget to follow my list of all 31 NFL teams that are on Twitter: nfl-teams
How To Use
Download the spreadsheet and run the StartForm procedure.
Select a team from the upper left listbox. The team logo is downloaded from NFL.com and stored in the local temp folder. Click the label below the team logo to visit the team's website.
Once you select a team, three listboxes are populated:
- A list of news items for the selected team from NFL.com (the listbox at the upper right)
- A list of news items for the selected team from Yahoo.com (the listbox below NFL.com)
- The last twenty items from the team's Twitter feed
In addition, NFL news from around the league, courtesy of ESPN.com, populates the listbox at the bottom. These items are not team-specific.
Select a NFL.com or Yahoo Sports news item to see the summary in the Summary box. Double-click the Summary box to visit either NFL.com or Yahoo for the full article.
The rest of the userform should be self-explanatory.
The VBA Project is unlocked so you can see how everything works.
The NFL logo is copyrighted by the NFL. JP Software Technologies is not endorsed by, or affiliated with, the NFL and is not responsible for the content of these feeds. This application is for private, non-commercial use only.