A Blog on Analytics and Marketing

SAS, Marketing, Predictive Modeling, Statistics

Archive for the ‘MS Office’ Category

Deploy your excel macros from a central file

Posted by phillippeng on October 7, 2009

There are some advantages of deploying your excel macros from a central file:

1. You can manage all your macros in one file. Especially, when you need to backup all your handy utility macros, it’s very convenient.
2. You can activate all the macros when you start Excel every time.

It’s quite easy to do so. You just need to save all your macros in a file called personal.xls in the excel start folder. The path should look like ‘C:\Program Files\Microsoft Office\OFFICE11\XLSTART\’.

Next time when you develop a new macro, save the macro in this personal.xls and your new macro will be added to this file.

Posted in Excel, MS Office | Tagged: | Leave a Comment »