#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
The best way to do this in PPT IS to have all your macros in a ppam AddIn that has ribbon buttons to run them. This would be available to all presentations.
There's a learning curve but we have a simple example here http://www.pptalchemy.co.uk/custom_UI.html A clumsy workaround is to have all the macros in a file that you always have open and call them with a simple macro like this Code:
Sub caller1 Application.Run "Master.pptm!macro1" End Sub I wouldn't do this. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
"IS" functions mixed with IF | driep01 | Excel | 4 | 02-07-2016 12:50 AM |
Need to restore custom functions from a corrupt ".xlam" file ... | gamouning | Excel | 1 | 11-12-2015 11:03 AM |
remove repeated words with " macro " or " wild cards " in texts with parentheses and commas | jocke321 | Word VBA | 2 | 12-10-2014 11:27 AM |
replace data from variable with "sub and super script" from excel to word by vba | krishnaoptif | Word VBA | 9 | 06-22-2012 05:08 AM |
How to choose a "List" for certain "Heading" from "Modify" tool? | Jamal NUMAN | Word | 2 | 07-03-2011 03:11 AM |