Advice Needed: PPT Workflow Automation
I am looking for advice. I have about 80 PPT workflows. Each is slightly different. When I need to update a universal piece, well, I have to update 80 PPTs.
Question: Is it possible to automate updating text inside of shapes using Excel? Sort of like a mail merge.
Over the past 3 months, I have researched solutions but can't find something on a larger scale that will accomplish my task.
I'm just looking for advice, and I can start researching based on your advice. Thank you.
Without knowing what at least one of the 80 looks like, this is a guess
I'd Use PP instead of Excel
Use Dir() to loop through the 80
Maybe have to loop through the slides in each PP
Maybe look through the textboxes on each slide to find the one to dhange
Change it
Save the PP
On to next
---------------------------------------------------------------------------------------------------------------------
Paul
Remember: Tell us WHAT you want to do, not HOW you think you want to do it
1. Use [CODE] ....[/CODE ] Tags for readability
[CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
2. Upload an example
Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
3. Mark the thread as [Solved] when you have an answer
Thread Tools (on the top right corner, above the first message)
4. Read the Forum FAQ, especially the part about cross-posting in other forums
http://www.vbaexpress.com/forum/faq...._new_faq_item3
Great, thank you.
Reply With Quote
