View Single Post
 
Old 10-26-2014, 12:19 PM
excelledsoftware excelledsoftware is offline Windows 7 64bit Office 2003
IT Specialist
 
Join Date: Jan 2012
Location: Utah
Posts: 455
excelledsoftware will become famous soon enough
Default

Quote:
Originally Posted by stevevrabel View Post
Well this should be fun.....I have never used VBA script so it will be a great learning experience. Thanks for this help. I'll let you know how it turns out.....may take me about 3 years to figure it out

Steve
lol You should give yourself more credit. Afterall you are going through and merging multiple presentations together that takes some skill. ( by the way we can alter the code to do that for you as well. Just a thought)

Since you have not done VBA before I will give you a quick how to.

Close all other presentations besides the one that you want to process
On your presentation with the all of the slides press ALT + F11
Go to INSERT > MODULE
paste the entire code from Sub to End Sub.
SAVE the presentation under a different name before running so you can go back if needed. VBA code does not have an undo command.
Place the cursor anywhere in the code and press the play button.
It will look like nothing happened because it will run very fast but go to your presentation and see the results.

From here you will come back to the forum and let us know if it did exactly what you wanted or if it needs to be "tweaked"

and again if we want to get the code to put all those slides together for you. Get comfortable running this one and then we can do just that.

Thanks
Reply With Quote