Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-15-2016, 11:50 PM
Xanthopteryx Xanthopteryx is offline Creating a "super macro" with all kind of functions Windows 7 64bit Creating a "super macro" with all kind of functions Office 2010 64bit
Novice
Creating a "super macro" with all kind of functions
 
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
  #2  
Old 06-16-2016, 01:38 AM
JohnWilson JohnWilson is offline Creating a "super macro" with all kind of functions Windows 7 64bit Creating a "super macro" with all kind of functions Office 2010 32bit
Programmer
 
Join Date: Nov 2008
Location: UK
Posts: 1,912
JohnWilson has a spectacular aura aboutJohnWilson has a spectacular aura about
Default

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
Where the master file is master.pptm and the macro is macro1

I wouldn't do this.
__________________
Microsoft PowerPoint MVP 2007-2023
Free Advanced PowerPoint Tips and Tutorials
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a "super macro" with all kind of functions "IS" functions mixed with IF driep01 Excel 4 02-07-2016 12:50 AM
Creating a "super macro" with all kind of functions 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
Creating a "super macro" with all kind of functions 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
Creating a "super macro" with all kind of functions How to choose a "List" for certain "Heading" from "Modify" tool? Jamal NUMAN Word 2 07-03-2011 03:11 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:10 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft