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…
The part 2 of the post which shows how to create a simple application with Windows Forms interface and SQL Server Database
This post explains how you can automatically install and activate an Excel Addin using VBA code. At the end you can also download the installation file.
A very easy tutorial about how to create in Visual Studio and SQL Server a simple application
Excel model which can help accountants analyze the aging of Accounts Receivable and calculate the Allowance for Doubtful Accounts and the Bad Debt Expense