Transfer content from one PowerPoint presentation to another automatically into corresponding placeholders

Hello,

I am a designer and need to produce a good number of PowerPoint presentations on a regular basis. The presentations follow the same structure - 11 slides with specified content for each one. I am preparing several graphic templates but they are quite complex and very structure specific so I am looking for a way to make all the content dynamically populated into styled placeholder text boxes, tables, charts and possibly smartart from an external file - simple Powerpoint, Word, Excel or similar.

The source files will be structured templates albeit much simpler graphically than the end result. And since the structure of the presentation doesn't change one source file template will be enough. I've listed multiple options but an unstyled powerpoint presentation as a source is very workable.

It is simply  a task of restyling that unfortunately falls beyond the templates functionality of PowerPoint. And i would like to avoid endless copying and pasting text and tables from one presentation (the source file) to another (the styled). Hence after researching I thought that VBA scripting can be an option.

What the application needs to do is grab the content of the first basic presentation and transfer it to corresponding placeholders in the styled presentation template.

When the presentation is populated with the content I will need to add additional images but ideally keep the dynamic links for the placeholders so that if the content in the external source file is changed the content in the presentation can be updated automatically without affecting the added elements. But this is optional.

Thank you

PS I have included a crude diagram of the basic process .
dynamic-placeholders2.png
Bogomil MihaylovDesign, Web & Digital media Creative / PhotogrpaherAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jamie GarrochPowerPoint Consultant & DeveloperCommented:
This expert suggested creating a Gigs project.
Hi Bogomil. What you're proposing is definitely technically feasible via the use of a VBA application. However, it is certainly not trivial and much more than a few lines of code in an EE question. This will require many hours of work. You might get a better response on EE if you posted this request as a paid-for gig. I have a lot of experience in writing VBA app's for PowerPoint with many commercial projects I can share and hence would be interested. The challenge will be to design a model whereby the app can identify what content from your multiple source files needs to go in which slide/layout/placeholder in the target presentation(s).
0
Bogomil MihaylovDesign, Web & Digital media Creative / PhotogrpaherAuthor Commented:
Thanks Jamie, sure i can imagine it can be a fairly complex solution.

However, I  probably wasn't clear enough and it appears more complex than it is. The source files will be structured templates albeit much simpler graphically than the end result. And since the structure of the presentation doesn't change one source file template will be enough. I've listed multiple options but an unstyled powerpoint presentation as a source is very workable.

It is simply  a task of restyling that unfortunately falls beyond the templates functionality of PowerPoint. And i would like to avoid endless copying and pasting text and tables form one presentation (the source file) to another (the styled). Hence after researching I thought that VBA scripting can be an option.

What the application needs to do is grab the content of the first basic presentation and transfer it to corresponding placeholders in the styled presentation template.

I hope this makes it clearer.
0
JSRWilsonCommented:
It would actually be much more difficult than you imaging. Placeholders have tricky properties - They can change name, shape and lose any code tags if you make ANY change. This means it would be difficult to reliably identify the correct ones.
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

Jamie GarrochPowerPoint Consultant & DeveloperCommented:
Thanks for the additional insight Bogomil. The project remains (a) technically feasible (b) non-trivial and (c) being better served as a gig because it meets criteria 1, 2 and 4 of the EE Gigs scope definition:

EE Gigs criteria
Both JSWilson and myself have many years experience developing these types of PowerPoint add-in solutions and we know how complicated it is to design something that on the surface does something simple.
0
Bogomil MihaylovDesign, Web & Digital media Creative / PhotogrpaherAuthor Commented:
Thanks both,

Can you please give me an estimate of how much a gig of this scope might cost to see if I can secure a budget on my end?
0
Jamie GarrochPowerPoint Consultant & DeveloperCommented:
Are you able to provide an example of the structured source presentation and the corresponding desired output styled presentation (made via your manual copy/paste process) in order to understand the scope a little better?
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
VBA

From novice to tech pro — start learning today.