Calling functions and subs from another file

Hi.

Having a lot of power point macros that clips in images and other stuff. All of them have a lot of functions and subs to do stuff (like comparing files, getting the newest file, aligning and so on) so the main code will be more easy to handle and maintain for some people not so into the VBA code.
This works great, but - if i wan't to update the subs and functions, i have to put the the updated code in EVERY macro and that is a pain in the ---.
So, is it possible to have the macro calling the functions from another file (like "Reference_Macro.whateverisneeded") so all the updates goes into that single file instead?

I can't install special software and that kind of stuff (at work you know...).

If this is possible, how do i implement this?

Regards X.

The best way to do this is to write a ppam AddIn with ribbon controls that make it available to all users.

You can though call code in other open presentations using

Code:

---

Application.Run ("the name of the code sub routine")

---

Quote:

---

Originally Posted by John Wilson

The best way to do this is to write a ppam AddIn with ribbon controls that make it available to all users.

You can though call code in other open presentations using

Code:

---

Application.Run ("the name of the code sub routine")

---

---

Thank you.

The ribbon AddIn, how does that work?

Regards X.

There is a very basic tutorial on our site but there is a learning curve.

Although it's for 2007 it also works the same in later versions.

http://www.pptalchemy.co.uk/custom_UI.html