Category: Excel
-
Application Deployment
Application Deployment for Access or Excel Apps; When distributing apps I usually create an install program to setup the application correctly for the user. I use Inno setup which does a great job of packaging the files creating the user shortcut and ensuring they have installed the program into the correct location. When deploying these…
-
Pension Calculator
As an accountant I get asked a lot about how long a persons pension pot will last or when I think they can retire. The honest answer is it depends ! What your current outgoings are , do you have debt , what age you are etc etc. I prepared this simple Excel model to…
-
Consolidate multiple excel sheets
This is a very useful macro to add the contents of several excel sheets onto a single sheet. Excel VBA Macro
-
Preserving Excel Comments Across versions
You may need to save excel comments from one excel model and load them into another file. This can be a time consuming task and this routine will eliminate if (Â big IF) you have a key column to store the comments on. In this case it was the crystal ID. You need an access database…
