A Blog on Analytics and Marketing

SAS, Marketing, Predictive Modeling, Statistics

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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: