View Single Post
 
Old 06-15-2016, 11:50 PM
Xanthopteryx Xanthopteryx is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Jun 2016
Posts: 1
Xanthopteryx is on a distinguished road
Default Creating a "super macro" with all kind of functions

Hi.

In an earlier version of office we used a lot of macros in word that referenced to a "super macro" that all word documents had access to. All kind of macros were saved in that and then referenced to from the actual word document.

Now we want to do the same here with PowerPoint (2010).

I want to have one place for all kind of functions (that i want to send and receive parameters to and from) that i can call from all PowerPoint documents we have macros in.

I.e. i have a function that i send a path and search criteria and then it returns the newest file name matching the criteria.
Another function gets two complete file name with path and then returns the one that is the most recent.
And one function gets the file name and then returns the file extension.

These, and many more, i want to have in One place (as for now, i have to implement them in all macros so when we add another function, every PowerPoint macro will have to be updated and there are A Lot of them).

I've tried figuring this out via Google but now I'm complete stuck.

Anyone that can give me some nice instructions on how to do it?
I'm quite a beginner on this so please, treat me as an idiot. =)

Note: No special downloadable addons and registry hack is possible due to restrictions in the system!

Regards X.
Reply With Quote