Advice needed: "Portable" macros?

[durex]

So on roughly a weekly basis a couple employees create an export of some
data to a new excel spreadsheet. I then have some macros that they need
to run against this new spreadsheet every week.

What would be the best way to give them access to these macros since
the spreadsheets theyre creating from these exports obvisouly wont have
them? Oh yea.. and these employees arent the most "technically
inclined", so the easier the better.

Ive been pondering this for half the day now and I know it cant be that
difficult of a thing to do....

Thanks!

 

[Mike Fogleman]

Put the macros in each of their Personal.xls workbooks. Then for
convenience, create a menu item on each of their Excel applications that
will run the macro.
I did this for my boss so he would quit sending me his stuff to process with
my macro. If you need any guidance in any way, post back. Of course you will
need access to their computers for a short while to do this for them.

Mike F

 

[RB Smissaert]

Put your macro's in an .xla add-in.
Plenty of good information about this available.
This may be good start:
http://www.fontstuff.com/vba/vbatut03.htm

RBS