I presented some examples of Excel VBA projects on my old blog. For most of them you will find also downloadable files, detailed explications and in some cases video tutorials. Unfortunately, the old site was mainly in Romanian, but I think you will understand most of the ideas even if you don’t know the language.
You can find all of them at this address: My Old Blog Projects
–> Some interesting selections could be:
- 1. Excel VBA app which automatically imports financial data from Bucharest Stock Exchange Website for all listed companies, calculates some financial indicators and scorings and finally generates in a new Workbook a report with the companies sorted descending by total score. The app contains ribbon customization and the data is scraped from site using VBA IE Automation.
- 2. Excel VBA app which calculates the bank loan rates (equal or decreasing) and a maximum recommended amount to contract a loan based on the monthly net income.
- 4. Smart Invoicer- Excel VBA app for issuing and analyzing sales invoices.
- 6. Working Days Analyzer- spreadsheet application which calculates the monthly worked days and the available hours: FTE
- 7. Running Performance Analyzer App- 2014- for tracking and analyzing runners data.
- 8. Online calculator for stock market investment scenarios.